2009/8/18 Terrence Brannon <scheme...@gmail.com>: > Hello, when converting a .sql file containing MySQL INSERT clauses, > one often runs into the problem that the MySQL INSERT can accept > multiple VALUES arguments: > > INSERT INTO actor VALUES (1,'PENELOPE','GUINESS','2006-02-15 > 04:34:33'),(2,'NICK','WAHLBERG','2006-02-15 > 04:34:33'),(3,'ED','CHASE','2006-02-15 04:34:33') > > whereas the SQLite INSERT can only take one... > > Is there any possibility of extending the syntax of the SQLite insert > to accept multiple VALUES arguments?
INSERT INTO actor SELECT 1,'PENELOPE','GUINESS','2006-02-15 04:34:33' UNION ALL SELECT 2,'NICK','WAHLBERG','2006-02-15 04:34:33' UNION ALL SELECT 3,'ED','CHASE','2006-02-15 04:34:33'; -- Kit _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users