mysql 查看表结构的方法参考

desc tablename;
show columns from tablename;
describe tablename;
show create table tablename;
use information_schema;
select * from columns where table_name='tablename';