1024programmer Mysql How to assign null to mysqldate

How to assign null to mysqldate

The method of assigning null to mysql date: 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.

3. Create a simple table, where the date time format supports NULL assignment, example:

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

More related free learning recommendations: mysql tutorial (video)

The above is how to assign mysql date For more details about null, please pay attention to other related articles on 1024programmer.com!

This article is from the internet and does not represent1024programmerPosition, please indicate the source when reprinting:https://www.1024programmer.com/how-to-assign-null-to-mysqldate/

author: admin

Previous article
Next article

Leave a Reply

Your email address will not be published. Required fields are marked *

Contact Us

Contact us

181-3619-1160

Online consultation: QQ交谈

E-mail: [email protected]

Working hours: Monday to Friday, 9:00-17:30, holidays off

Follow wechat
Scan wechat and follow us

Scan wechat and follow us

Follow Weibo
Back to top
首页
微信
电话
搜索