> no it's not possible > > just insert them in a while or for each statement > > -----Original Message----- > From: Shaun [mailto:shaun@mania.plus.com] > Sent: vrijdag 9 mei 2003 16:14 > To: php-db@lists.php.net > Subject: Insert multiple records > > > Hi, > > Is it possible to insert multiple records into a table with only one command > i.e. > > INSERT INTO Table (Column) VALUES (A, B, C ....) > > Thanks for your help > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > You can, INSERT INTO TABLE dummy (<column list>) VALUES (a,b,c),(a2,b2,c2),(a3,b3,c3).... Regards, Thomas =============================================== Thomas Sinka mobil: +49 163 3 23 12 72 mailto: thomas.sinka@it-choice.de IT-Choice Software AG Kaiserstraße 160-162, 76133 Karlsruhe, Germany Tel.: +49(0)721-85 006-0, Fax: +49(0)721-85 006-77 www.it-choice.de, info@it-choice.de Amtsgericht Karlsruhe, HRB 9060 USt-Id Nr.: DE 812 950 635 Vorstand: Mirko Ketterer (Vorsitzender), Stephanie Lehmann, Dirk Ludwig Aufsichtsratsvorsitzender: Horst Gann -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
