创建表
CREATE TABLE `cms_test` (
	`id` INT NOT NULL AUTO_INCREMENT,
	`created_at` INT NOT NULL DEFAULT '0',
	`updated_at` INT NOT NULL DEFAULT '0',
	`deleted_at` INT NOT NULL DEFAULT '0',
	PRIMARY KEY (`id`)
)
COMMENT='测试表'
COLLATE='utf8_general_ci'
ENGINE=InnoDB;

修改表
ALTER TABLE `cms_test` COMMENT='测试2表';
RENAME TABLE `cms_test` TO `cms_test2`;

//添加字段
ALTER TABLE `cms_test` ADD COLUMN `nn` INT(11) NOT NULL DEFAULT '0' COMMENT '那你';
ALTER TABLE `cms_test` ADD COLUMN `beizhu` VARCHAR(50) NULL COMMENT '备注';



