On Mon, 2008-01-07 at 15:00 -0800, Brian Marshall wrote: > I can't testify for any other database, but mysql lets you use the same > syntax for both operations. > > INSERT INTO `foo` SET `bar` = 'foobar' > UPDATE `foo` SET `bar` = 'wombat' WHERE `bar` = 'foobar' > > I find the VALUES() syntax horribly unnatural and disjointed. I refuse > to use it.
Yes, mysql does take even more liberties with SQL than any of the other databases I can think of. Which is really quite hateful most of the time. Cheers, Martin.
