How to insert mysql date into null

This article is about how to insert mysql date into null. The editor thought it was very practical, so I shared it with you as a reference. Let's follow the editor and have a look.

Mysql date inserts null by first connecting to the MySQL server, then using the use keyword to complete the library selection operation, and finally inserting a NULL into the date data type with the code [insert into user (time) values (null)].

The method of inserting mysql date into null:

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

Mysql-u user-p

2. Use the use keyword to complete the library selection operation, for 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. Insert a NULL into the date data type in the time field, for example:

Insert into user (time) values (null)

5. After querying, a NULL has been successfully inserted into the Date data type. Example:

Select * from user

Thank you for reading! On how to insert mysql date null to share here, I hope the above content can be of some help to you, so that you can learn more knowledge. If you think the article is good, you can share it and let more people see it.