mysql查看表结构的方法

mysql> show fields from task_fee_tpl;
+----------+-------------+------+-----+---------+----------------+
| Field    | Type        | Null | Key | Default | Extra          |
+----------+-------------+------+-----+---------+----------------+
| id       | smallint(6) | NO   | PRI | NULL    | auto_increment |
| name     | varchar(64) | YES  |     |         |                |
| content  | text        | YES  |     | NULL    |                |
| tpl_file | varchar(64) | YES  |     |         |                |
| strJSON  | text        | YES  |     | NULL    |                |
+----------+-------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)

mysql> SHOW COLUMNS FROM task_fee_tpl;
+----------+-------------+------+-----+---------+----------------+
| Field    | Type        | Null | Key | Default | Extra          |
+----------+-------------+------+-----+---------+----------------+
| id       | smallint(6) | NO   | PRI | NULL    | auto_increment |
| name     | varchar(64) | YES  |     |         |                |
| content  | text        | YES  |     | NULL    |                |
| tpl_file | varchar(64) | YES  |     |         |                |
| strJSON  | text        | YES  |     | NULL    |                |
+----------+-------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)

mysql> SHOW COLUMNS FROM task_fee_tpl;
+----------+-------------+------+-----+---------+----------------+
| Field    | Type        | Null | Key | Default | Extra          |
+----------+-------------+------+-----+---------+----------------+
| id       | smallint(6) | NO   | PRI | NULL    | auto_increment |
| name     | varchar(64) | YES  |     |         |                |
| content  | text        | YES  |     | NULL    |                |
| tpl_file | varchar(64) | YES  |     |         |                |
| strJSON  | text        | YES  |     | NULL    |                |
+----------+-------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)

mysql>