11 messages in com.mysql.lists.mysqlRE: UPDATE problems
FromSent OnAttachments
Nikolai Devereaux05 Jun 2002 09:54 
Jay Blanchard05 Jun 2002 10:13 
Mark Stringham05 Jun 2002 10:24 
Nikolai Devereaux05 Jun 2002 10:34 
Chris Hohimer05 Jun 2002 10:53 
Anil Garg05 Jun 2002 11:20 
Chris Hohimer05 Jun 2002 11:26 
Anil Garg05 Jun 2002 11:44 
Cal Evans05 Jun 2002 11:53 
Mark Stringham05 Jun 2002 14:26 
Cal Evans05 Jun 2002 16:08 
Subject:RE: UPDATE problems
From:Jay Blanchard (jay.@niicommunications.com)
Date:06/05/2002 10:13:18 AM
List:com.mysql.lists.mysql

[snip] tbl key int, primary key, auto increment val int

I've inserted several dummy values so that my table looks like this:

key val 1 50 2 100 3 150 4 200

I can successfully run this query:

UPDATE tbl SET val = val + 1

but THIS query fails:

UPDATE tbl SET val = val + 1 WHERE key = 2 [/snip]

Isn't 'key' a reserved word?

HTH!

Jay