Jan Wieck wrote: > On 7/11/2006 1:08 PM, Scott Marlowe wrote: > >> On Tue, 2006-07-11 at 11:04, Jan Wieck wrote: >>> On 6/30/2006 1:07 PM, Merlin Moncure wrote: >>> >>> > * mysql has a few features here and there which are nice...just to >>> > name a few, flush tables with lock, multiple insert, etc >> >>> The multiple insert stuff is not only non-standard, it also >>> encourages the bad practice of using literal values directly in the >>> SQL string versus prepared statements with place holders. >> >> I thought it was in the SQL 99 standard... > > The SQL bible doesn't say SQL99, it says it is a DB2 specific feature.
hmm: http://troels.arvin.dk/db/rdbms/#insert says otherwise - or are we talking a different "multiple insert" ? Stefan ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
