Multiple MySQL Commands

wxdqz

New Member
Hi All,

I've looked through the MySQL docs, but I can't find a reference to importing various commands into the command line. Please do not confuse this with LOAD DATA INFILE - I mean to be carrying out multiple SQL commands with the minimum of fuss.

For example:

DELETE FROM table1;
LOAD DATA INFILE 'whatever.csv' INTO TABLE table1;
DELETE FROM table2;

I plan to do this for 18 different tables.

Cheers,

David
 
Back
Top