The command you need is 
source <filename> ;
Alternatively, if you are outside the mysql clined
mysql < <filename>

        Alec




"Joppe A" <[EMAIL PROTECTED]> 
04/04/2005 09:59

To
mysql@lists.mysql.com
cc

Subject
how to run a file in MySQL






Hello all,

This is probably really basic for all of you but I have been trying to 
find it in the manual without success... 

My question is if it is possible when you are logged in to MySQL to run a 
file with sql-statements in, instead of sit and execute each statement 
seperatly. 
The file I have is a to clean up my DB and to erase data that I don#t want 
to have, som all rows in the file is normal DELETE-statetments.

Thanks in advance!

/Joppe
-- 
___________________________________________________________
Sign-up for Ads Free at Mail.com
http://promo.mail.com/adsfreejump.htm


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    
http://lists.mysql.com/[EMAIL PROTECTED]




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to