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 (两3000) − Column 'ShippingDate' cannot be null
登录后复造
Now, 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.二1 sec
登录后复造
Display all records from the table using select statement −
mysql> select *from DemoTable;
登录后复造
那将孕育发生下列输入 −
+--------------+ | ShippingDate | +--------------+ | NULL | +--------------+ 1 row in set (0.00 sec)
登录后复造
以上即是MySQL 盘问使日期列为 NULL？的具体形式，更多请存眷萤水红IT仄台此外相闭文章！
发表评论 取消回复