CREATE TABLE IF NOT EXISTS `tableName` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`job` varchar(255) NOT NULL COMMENT '固定长度字符',
`text` TEXT NOT NULL COMMENT '短数据,最大长度65535',
`MediumText` MEDIUMTEXT NOT NULL COMMENT '中数据,最大长度16777215',
`LongText` LONGTEXT NOT NULL COMMENT '长数据,最大长度4294967295',
`createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET='utf8' COMMENT='表解释';
sql语句创建表格
最新推荐文章于 2024-07-18 09:45:00 发布