Hi
insert into mytbl (a1) values (12),(13),(14); cheers Mark ----------------------------------------------------------- On Mon, 15 Apr 2002, Bill Adair wrote: > 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
