--- Sander Marechal <[EMAIL PROTECTED]> wrote: > I ran into a problem when using SQLite from PHP. It appears that SQLite3 > does not support multi-row inserts in the form: > > INSERT INTO (col1, col2) VALUES (1, 2), (3, 4) > > Is that correct?
That's correct. > Will if be implemented in the future? I doubt it. However, you might try: http://www.mail-archive.com/sqlite-users@sqlite.org/msg28337.html Or you could do the equivalent: INSERT INTO t1(col1, col2) SELECT 1, 2 UNION ALL SELECT 3, 4; ____________________________________________________________________________________ Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
