mysql 查看表结构_MySQL

bitsCN.com

desc tablename;

show columns from tablename;

describe tablename;

show create table tablename;

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

bitsCN.com