On Mon, 7 Jan 2008 13:49:56 -0600 Jeremy Stephens <jeremy.f.steph...@vanderbilt.edu> wrote:
> Why is the UPDATE syntax so different from INSERT? If I'm > constructing a SQL statement to insert or update based on the > existence of a row in some code, I have to have two completely > different cases to handle it. What were the SQL creators thinking? > > What's strange is that I've been working with SQL for years and I've > never considered the syntax difference annoying. > > Avast! 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. Brian
signature.asc
Description: PGP signature