How to assign null to mysql date

Mysql date assignment method to null: First connect to the MySQL server through the client, use the use keyword to complete the database selection operation; then create a table and insert NULL into the date data type in the time field.

Mysql date assignment method to null:

1. First connect to the MySQL server through the client, example:

mysql -u user -p

2. Use the use keyword to complete the database selection operation. Example:

use database name;

3. Create a simple table in which the date time format supports NULL assignment. Example:

create table user(
id int(10) auto_increment primary key,
time date);

4. Think of the time field Insert a NULL into the date data type in, example:

insert into user (time) values (null);

5. Check, a NULL is successfully inserted into the Date data type, example:

select * from user;

More related free learning recommendations: mysql tutorial(video)

The above is the detailed content of How to assign null to mysql date. For more information, please follow other related articles on the PHP Chinese website!