mysql语句

显示表的索引：
show index from table_name;

添加索引:
alter table test.hat_area add index new_index2(id)

创建表：
createtable Employee
(
ID int auto_increment,
Ename varchar(32),
Age int,
Salary float,
MID int,
Primarykey (ID)
)ENGINE=MyISAM DEFAULT CHARSET=utf-8;

显示建表语句：
show create table table_名

 

转载于:https://www.cnblogs.com/lnas01/p/5353871.html