Re: pgsql vs mysql

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.


Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #