11/23: MySQL > Updating Data (UPDATE)
Category: Study
Posted by: hajime osako
The UPDATE statement does not have any effect if the statement does not actually change any column values, even there is a TIMESTAMP column with ON UPDATE CURRENT_TIMESTAMP.
You can use ORDER BY and LIMIT in the UPDATE statement.
The --safe-updates option is for preventing dangerous UPDATE statement, such as no WHERE clause.
You can use ORDER BY and LIMIT in the UPDATE statement.
The --safe-updates option is for preventing dangerous UPDATE statement, such as no WHERE clause.