首页 > 其他分享 >[Error fix] Incorrect date value: '0000-00-00'

[Error fix] Incorrect date value: '0000-00-00'

时间:2022-10-18 16:38:01浏览次数:44  
标签:Incorrect ENGINE 00 0000 NO ZERO DATE GROUP

SELECT @@sql_mode;
= 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
SET @@sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
SET @@sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';


ALTER TABLE `database`.`tab`
MODIFY COLUMN `return_bill_number` varchar(255) NOT NULL DEFAULT '' COMMENT '归还单号' AFTER `return_at`

 

标签:Incorrect,ENGINE,00,0000,NO,ZERO,DATE,GROUP
From: https://www.cnblogs.com/denghuachengle/p/16803012.html

相关文章