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
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