List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:July 1 1999 1:22pm
Subject:Re: Executing several SQL commands at once
View as plain text  
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')

Regards,
  Martin
-- 
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
Thread
Executing several SQL commands at onceArnaud D.1 Jul
  • Re: Executing several SQL commands at onceAlan Morey1 Jul
  • Re: Executing several SQL commands at onceMartin Ramsch1 Jul
RE: Executing several SQL commands at onceNigel Parker1 Jul