MySQL 字段 0000-00-00 00:00:00
2020-12-09 本文已影响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
