摘要： mysql查看表结构命令：1.show columns from tablename　| desc tablename | describe tablename　//查看表字段2.show create table tablename //各个字段的设置信息mysql修改索引命令：1.alter table tablename add index (fields1,fields2....);2.alter table tablename drop index (fileds1,fields2....);============================================.. 阅读全文