sqlite> CREATE TABLE test_table ...> (col1 INTEGER NOT NULL, ...> col2 CHAR(25)); sqlite> insert into test_table (col1, col2) values (1, 'ab'); sqlite> insert into test_table (col1, col2) values (1, 'ab'),(2, 'bc'); Error: near ",": syntax error
As of SQLite 3.7.11 (Ubuntu has 3.7.9 installed), this syntax is possible: http://sqlite.org/releaselog/3_7_11.html
Older responses on Stack Overflow state that it doesn't, referring to the diagram from the SQLite documentation. But this diagram has already been updated to reflect this new change:

No comments:
Post a Comment