UPDATE table SET column=expression,... WHERE where_definition
All updates are done from left to right. If one accesses a column in the expression, update will then use the current value (a given value or the default value) of the column.
UPDATE persondata SET count=count+1
A UPDATE statements returns how many rows was actually changed.
In MySQL 3.22 mysql_info() returns the number of rows that was
matched and updated and how warnings one got during the update.
Go to the first, previous, next, last section, table of contents.