查看索引 show index from table_name; show keys from table_name; 新建索引 alter table table_name add index index_name(column_name); 删除索引 alter table table_name drop index index_name;
查看字符编码
show full columns from table_name; show create table table_name;