Hello all, I'm in a mysql client session and I want to do multiple inserts into a table (or run a multi-query script etc). This doesn't work so what's the correct seperator / methodology?
INSERT INTO mytbl (a1) VALUES (12); INSERT INTO mytbl (a1) VALUES (13); INSERT INTO mytbl (a1) VALUES (14); \g TIA Bill --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php