On Sep 17, 2011, at 6:04 PM, Simon Slavin wrote: > Can you find the syntax that allows
These ANSI specifications are notoriously difficult to pinpoint :) DB2: http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/admin/r0000970.htm INSERT INTO DEPARTMENT (DEPTNO, DEPTNAME, ADMRDEPT) VALUES ('B11', 'PURCHASING', 'B01'), ('E41', 'DATABASE ADMINISTRATION', 'E01') MySQL: http://dev.mysql.com/doc/refman/5.1/en/insert.html INSERT INTO tbl_name (a,b,c) VALUES(1,2,3),(4,5,6),(7,8,9); PostgreSQL: http://www.postgresql.org/docs/8.2/static/sql-insert.html INSERT INTO films (code, title, did, date_prod, kind) VALUES ('B6717', 'Tampopo', 110, '1985-02-10', 'Comedy'), ('HG120', 'The Dinner Game', 140, DEFAULT, 'Comedy'); SQL Server: http://msdn.microsoft.com/en-us/library/dd776382.aspx INSERT INTO Production.UnitMeasure VALUES (N'FT2', N'Square Feet ', '20080923'), (N'Y', N'Yards', '20080923'), (N'Y3', N'Cubic Yards', '20080923'); Pretty consistent syntax across vendors, and not totally outlandish to presume it's a "standard" from the point of view of the casual dilettante :) Sadly, there is no such thing as "standard sql" :)) Still, in the case of SQLite as with any other product, the fine manual is there to sort this out: "SQL As Understood By SQLite" http://www.sqlite.org/lang.html _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
