To make a date column null, use ALTER TABLE and MODIFY and set the date to NULL. Following is the syntax −alter table yo
To make a date column null, use ALTER TABLE and MODIFY and set the date to NULL. Following is the syntax −
alter table yourTableName modify column yourColumnName date NULL;首先让我们创建一个表格。在这里，我们将列设置为NOT NULL −
Mysql> create table DemoTable
(
ShippingDate date NOT NULL
);
Query OK, 0 rows affected (0.78 sec)Now, insert NULL value in the above table. An error would generate since we have set the column to be NOT NULL −
mysql> insert into DemoTable values(null);
ERROR 1048 (23000) − Column 'ShippingDate' cannot be nullNow, let us alter the table and allow NULL in the above table −
mysql> alter table DemoTable modify column ShippingDate date NULL;
Query OK, 0 rows affected (1.81 sec)
Records : 0 Duplicates : 0 Warnings : 0现在，再次尝试使用插入命令将NULL插入到上述表中。由于我们已经修改了表以接受NULL，所以不会生成错误−
mysql> insert into DemoTable values(null);
Query OK, 1 row affected (1.21 secDisplay all records from the table using select statement −
mysql> select *from DemoTable;这将产生以下输出 −
+--------------+
| ShippingDate |
+--------------+
| NULL |
+--------------+
1 row in set (0.00 sec)--结束END--
本文标题: MySQL 查询使日期列为 NULL？
本文链接: https://lsjlt.com/news/439277.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
2024-10-23
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
官方手机版
微信公众号
商务合作
0