On Do, 1999-07-01 15:06:46 +0200, Arnaud Dostes wrote:
> How can i execute several SQL commands in an SQL window for mySQL ?
Please, what do you mean with "SQL windows for mySQL"?
What program are you using to send your SQL queries?
> This is what I do :
> INSERT INTO TABLE mytable VALUES ('aaa')
> INSERT INTO TABLE mytable VALUES ('bbb')
Not exactly the answer to your question, but you can condense serveral
similiar INSERT statements of this kind into a single one:
INSERT INTO TABLE mytable VALUES ('aaa'), ('bbb'), ('ccc')
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26 E4 EC 80 58 7B 31 3A D7