desc tablename;show columns from tablename;describe tablename;show create table tablename;use information_schema;select * from columns where table_name='tablename';
转载于:https://www.cnblogs.com/hailspace/p/3408974.html
