mysql显示一张表的索引以及如何快速复制一张表结构和表数据
show index from tablename
create table AAA as select * from BBB
insert into AAA
select * from BBB
------------------------- A little Progress a day makes you a big success... ----------------------------
show index from tablename
create table AAA as select * from BBB
insert into AAA
select * from BBB