Re: Running multiple queries using "MySql" client

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). Thi

Running multiple queries using "MySql" client

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); \