[Resolved] increment value in a table

[doublehops]

I have been having trouble finding a solution to this that works so I hoped you guys could help.

I am trying to automatically increment a value without working out what value it is already. The query I am trying is this.

 UPDATE test SET order = order +1 WHERE id = '1' 

Both the 'id' and 'order' are column type of int. From what I can tell this should be fine but mysql is returning a syntax error.

Any suggestions would be appreciated.

Thanks,
Damien.

[zhabala]

This really should be ok, but you can try:

UPDATE test SET order = order + 1 WHERE id = 1

[Ravenous]

how about showing us the error itself?

[doublehops]

Thanks for your help guys. I came back to the problem this morning with a clear head and worked out that you shouldn't have a column named 'order' because that word is used in queries. Works fine after I renamed the column to pg_order.

Thanks again,
Damien.