mysql show create table_mysql show create table `tablename` 查看建表语句

mysql> show create table tb_common_member;

+------------------+------------------------------------------------

----+

| Table            | Create Table

|

+------------------+------------------------------------------------

----+

| tb_common_member | CREATE TABLE `tb_common_member` (

`uid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,

PRIMARY KEY (`uid`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 |

+------------------+------------------------------------------------

----+

1 row in set (0.00 sec)

mysql>

3、use information_schema;select * from columns where table_name='tablename'例如：要查看jos_modules表结构的命令：use information_schema;select * from columns where table_name='jos_modules';查看结果：

mysql> select table_name from columns where table_name = 'tb_common_member';

+------------------+

| table_name       |

+------------------+

| tb_common_member |

+------------------+

1 row in set (0.04 sec)

mysql>