MySQL查看表结构命令

desc Tablename;51Testing软件测试网K1q8w'D.] ^
51Testing软件测试网Jz3g6o|
describe Tablename;
am3c@s]*? R0
%C Nwt+c8C@"r0show columns from Tablename;51Testing软件测试网XGnh1q-Z$v!\-g
51Testing软件测试网3O1_W |1I$w#|,m0_(n
show create table Tablename;
}&c8E!o @7u3Jv-z+r0备注:显示了建库脚本。
HX$x3g0yI*D0
"ad3@$t%g;U~3e5f6ob|/p0use information_schema51Testing软件测试网$]$eR:EW#{
select * from columns where table_name='Tablename';51Testing软件测试网,wGNR8P.c\'G
e
备注：显示了权限。