sql update statement writing:
UPDATE table_name SET column1=value1,column2=value2,... WHERE some_column=some_value;
Note:
The WHERE clause specifies which record or records need to be updated . If you omit the WHERE clause, all records will be updated!
In MySQL, you can solve this problem by setting the built-in parameter sql_safe_updates
. When this parameter is turned on, you must carry the where condition after the update statement. Otherwise, an error will be reported.
Opening method:
set sql_safe_updates=1; 表示开启该参数
Recommended tutorial: mysql tutorial
The above is the detailed content of How to write sql modification statement. For more information, please follow other related articles on the PHP Chinese website!