Re: db insert question
| From: | Duncan Hill | Date: | Thu, 21 Jul 2005 14:08:14 +0000 |
| Subject: | Re: db insert question | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-219122@lists.php.net to get a copy of this message | ||
On Thursday 21 July 2005 15:02, Jim Moseby typed:
> As far as I know, there is no way to insert 20 unique rows of data into a
> MySQL table without executing 20 queries. Maybe someone else here does(?).
> Perhaps drop a note over on the MySQL list, since this is really more an
> SQL question than PHP. Sorry I couldn't help.
Yes, MySQL supports an extended insert syntax of insert into foo (...) values
(...), (...), (...).
Building that kind of query is left as an excercise for the user. I believe
the PEAR DB abstraction layer can accept an array to generate that kind of
query.
--
My mind not only wanders, it sometimes leaves completely.