mysql 查看表结构

desc tablename;

show columns from tablename;

describe tablename;

show create table tablename;

use information_schema;
select * from columns where table_name='tablename';