Posted by Piotr on 10/02/41 11:46

I wanto set next max number from 'number' field +1 when I update any
record. I tryied to do like this:

UPDATE table set number=(select MAX(number)+1 from table) WHERE Id=122

but I got error 1093

How can I do it? It can't be autoincrement. I must be sure if nobody
else got the same number in the same time.

• Next in forum: need help w/ outputting to a textarea
• Prev in forum: How can I get all enum values of field SMTH?
• Thread view: [mysql] subquery and update

[Reply to this message]