Mysql 建表索引
– 创建表
DROP TABLE
IF
EXISTS department;
CREATE TABLE department (
id INT ( 11 ) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
code VARCHAR ( 100 ) DEFAULT NULL COMMENT ‘编号’,
name VARCHAR ( 255 ) DEFAULT NULL COMMENT ‘名称’,
PRIMARY KEY ( id ),
UNIQUE KEY index_code (
原创
2021-07-12 08:58:31 ·
3410 阅读 ·
0 评论