On Tue, Aug 18, 2009 at 08:28:13AM -0500, Beau Wilkinson scratched on the wall: > To me that seems like an annoying deviation from standard practice. > Do other databases support such an INSERT?
Yes. MySQL, PostgreSQL, and SQLServer all support this syntax. Oracle supports a slightly modified syntax that allows multple rows to be inserted into multiple tables with one INSERT ALL. The syntax for that is basically INSERT ALL INTO... INTO... INTO... DB2 and HSQL (and SQLite) do not support this. Personally, I think the first syntax would be a nice enhancement. It is also worth noting that every non-SQL Relational language (e.g. Tutorial-D) I've looked at supports some form of multiple inserts, usually into multiple tables, with one command. If you're a stickler for constraints, and believe enforcement shouldn't be delayed (as most theory-heavy folks do), you have to have something like this. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Our opponent is an alien starship packed with atomic bombs. We have a protractor." "I'll go home and see if I can scrounge up a ruler and a piece of string." --from Anathem by Neal Stephenson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
