--- 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]
-----------------------------------------------------------------------------

Reply via email to