|
|
Posted by Duncan Hill on 07/21/05 17:08
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.
Navigation:
[Reply to this message]
|