[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