On Sat, 17 Sep 2011 16:23:23 +0100, Simon Slavin <slav...@bigfraud.org> wrote:
> >On 16 Sep 2011, at 8:27pm, Jim Michaels wrote: > >> INSERT is supposed to handle multiple rows for VALUES. >> for example, >> INSERT INTO table(digit,dialpadstr) VALUES >> (2,'abc'), >> (3,'def'), >> (4,'ghi'), >> (5,'jkl'), >> (6,'mno'), >> (7,'pqrs'), >> (8,'tuv'), >> (9,'wxyz'); > >Can you find support for that 'supposed' in the specification for SQL ? Probably not. See: http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt Specifically: Page 390, Chapter 13.8, leveling rules, rule 2a. Page 648, Rule 63a. -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
