查看“︁Mysql查看表结构”︁的源代码

&nbsp;

desc 表名; &nbsp;<br/> show columns from 表名; &nbsp;<br/> describe 表名; &nbsp;<br/> show create table 表名; &nbsp;<br/> use information_schema &nbsp;<br/> select * from columns where table_name='表名'; &nbsp;

<br/> http://database.51cto.com/art/201005/199576.htm

&nbsp;

[[ Category:&nbsp;mysql ]]