Mysql method of modifying a field to null

This article will explain in detail the method of changing the field of mysql to null for you. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

Mysql to modify the field to null method: 1, create a new query, use statements to set; 2, double-click to open the table, through time sorting to find the record that needs to be modified, and directly right-click on the [finish_time] of the record to set null.

Mysql method to modify the field to null:

1. Sql syntax

Create a new query and use the statement to set: update p_order set finish_time=null where id='XXXX'

2. Set in navicat for mysql

Double-click to open the p_order table, through the time sorting to find the record that needs to be modified, directly right-click on the finish_time of the record (no need to delete data), right-click will be set to Null (English: Set to Null), the result will have been set to the Null value.

On the mysql to modify the field to null method to share here, I hope that the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.