mysql创建表
CREATE TABLE `post` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '表id',
`title` varchar(100) NOT NULL COMMENT '标题',
`content` varchar(5000) NOT NULL COMMENT '内容',
`updatetime` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
PRIMARY KEY (`id`),
KEY `id` (`id`),
KEY `title` (`title`),
KEY `updatetime` (`updatetime`)
) ENGINE=InnoDB AUTO_INCREMENT=59471 DEFAULT CHARSET=utf8;
mysql新增字段
alter table post add comment varchar(2000) not null default 'notset'
comment '评论' after content;