1,desc tablename;
mysql> desc authors;+-------+--------------+------+-----+---------+----------------+| field | type | null | key | default | extra |+-------+--------------+------+-----+---------+----------------+| id | int(11) | no | pri | null | auto_increment || email | varchar(100) | no | uni | null | || name | varchar(100) | no | | null | |+-------+--------------+------+-----+---------+----------------+3 rows in set
2,show create table tablename; mysql> show create table authors;+---------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+| table | create table |+---------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+| authors | create table `authors` ( `id` int(11) not null auto_increment, `email` varchar(100) not null, `name` varchar(100) not null, primary key (`id`), unique key `email` (`email`)) engine=innodb auto_increment=2 default charset=utf8 |+---------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+1 row in set
3,select * from columns where table_name='表名'mysql> use information_schema;
database changed
mysql> select * from columns where table_name='authors';
+---------------+--------------+------------+-------------+------------------+----------------+-------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+-----------------+--------------+------------+----------------+---------------------------------+----------------+
| table_catalog | table_schema | table_name | column_name | ordinal_position | column_default | is_nullable | data_type | character_maximum_length | character_octet_length | numeric_precision | numeric_scale | character_set_name | collation_name | column_type | column_key | extra | privileges | column_comment |
+---------------+--------------+------------+-------------+------------------+----------------+-------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+-----------------+--------------+------------+----------------+---------------------------------+----------------+
| def | zqad | authors | id | 1 | null | no | int | null | null | 10 | 0 | null | null | int(11) | pri | auto_increment | select,insert,update,references | |
| def | zqad | authors | email | 2 | null | no | varchar | 100 | 300 | null | null | utf8 | utf8_general_ci | varchar(100) | uni | | select,insert,update,references | |
| def | zqad | authors | name | 3 | null | no | varchar | 100 | 300 | null | null | utf8 | utf8_general_ci | varchar(100) | | | select,insert,update,references | |
+---------------+--------------+------------+-------------+------------------+----------------+-------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+-----------------+--------------+------------+----------------+---------------------------------+----------------+
3 rows in set