On 17 Sep 2011, at 4:52pm, Petite Abeille wrote: > On Sep 17, 2011, at 5:11 PM, Igor Tandetnik wrote: > >> Supposed by whom? What is the basis for this claim? > > SQL-92: > > http://en.wikipedia.org/wiki/Insert_(SQL)#Multirow_inserts
Here's a draft of SQL-92. You can find the INSERT statement on page 388 et seq.. <http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt> Can you find the syntax that allows >> INSERT INTO table(digit,dialpadstr) VALUES >> (2,'abc'),(3,'def'),(4,'ghi'),(5,'jkl'),(6,'mno'),(7,'pqrs'),(8,'tuv'),(9,'wxyz'); ? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users