1.创建表删除表
CREATE TABLE `cms_category` (
`category_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '类目编号',
`pid` int(10) unsigned DEFAULT NULL COMMENT '上级编号',
`level` tinyint(4) NOT NULL COMMENT '层级',
`name` varchar(20) NOT NULL COMMENT '名称',
`description` varchar(200) DEFAULT NULL COMMENT '描述',
`icon` varchar(50) DEFAULT NULL COMMENT '图标',
`type` tinyint(3) NOT NULL DEFAULT '1' COMMENT '类型(1:普通,2:热门...)',
`alias` varchar(20) DEFAULT NULL COMMENT '别名',
`ctime` bigint(20) unsigned NOT NULL COMMENT '创建时间',
`orders` bigint(255) unsigned NOT NULL COMMENT '排序',
PRIMARY KEY (`category_id`),
KEY `cms_category_orders` (`orders`),
KEY `cms_category_pid` (`pid`),
KEY `cms_category_alias` (`alias`),
KEY `cms_category_level` (`level`),
CONSTRAINT `FK_Reference_10` FOREIGN KEY (`pid`) REFERENCES `cms_category` (`category_id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='类目表';
drop table `cms_category`
2.添加,删除字段
alert table 表名 add 列名 列定义
ALTER TABLE `cms_category` MODIFY `description` BIGINT NOT NULL DEFAULT 100;
alert table t1 drop d1
3.添加,删除索引
create index 索引名 on 表名(字段1,字段2 ...)
drop index 索引名 on 表名