How to modify a field to null in mysql

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!