Mysql method to modify the field to null: 1. Create a new query and use statement settings; 2. Double-click to open the table, sort by time to find the record that needs to be modified, and click on the [finish_time] of the record Just right-click and set null.
Mysql method to modify the field to null:
1, sql syntax
Create a new query and use the statement setting: update p_order set finish_time=null where id='XXXX'
2. Set in navicat for mysql
Double-click to open the p_order table, find the record that needs to be modified by sorting by time, and right-click on the finish_time of the record (no need to delete the data). After right-clicking, it will be set to Null (English: Set to Null), and the result will be Has been set to Null value.
Related free learning recommendations:mysql database(Video)
The above is the detailed content of How to modify a field to null in mysql. For more information, please follow other related articles on the PHP Chinese website!