美文网首页
MySQL 字段 0000-00-00 00:00:00

MySQL 字段 0000-00-00 00:00:00

作者: 阳光也学会了妩媚 | 来源:发表于2020-12-09 08:28 被阅读0次

datetime(0) NOT NULL DEFAULT '0000-00-00 00:00:00' 失败

SET GLOBAL sql_mode='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

表统计

SELECT TABLE_NAME,TABLE_ROWS,DATA_LENGTH/1024/1024 "DATA_LENGTH",CREATE_TIME,TABLE_COLLATION FROM

 INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'test' ORDER BY TABLE_ROWS DESC

SELECT TABLE_NAME,TABLE_ROWS,DATA_LENGTH/1024/1024 "DATA_LENGTH",TABLE_COMMENT,CREATE_TIME,TABLE_COLLATION FROM

 INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'jc_cainiaosys' ORDER BY TABLE_ROWS DESC

相关文章

网友评论

      本文标题:MySQL 字段 0000-00-00 00:00:00

      本文链接:https://www.haomeiwen.com/subject/hpbcgktx.html