语法
DESCRIBE <数据表>;
效果
MariaDB [xc]> DESCRIBE pac;
+-------------------------+------------------+------+-----+---------------------+-------------------------------+
| Field | Type | Null | Key | Default | Extra |
+-------------------------+------------------+------+-----+---------------------+-------------------------------+
| ID | int(11) | NO | PRI | NULL | auto_increment |
| SN | varchar(50) | YES | | | |
| local_wps | text | YES | | NULL | |
| result_wps | varchar(20) | YES | | NULL | |
| local_motionpro | tinytext | YES | | NULL | |
| result_motionpro | varchar(20) | YES | | NULL | |
| local_pnxclienthost | tinytext | YES | | NULL | |
| result_pnxclienthost | varchar(20) | YES | | NULL | |
| local_slclient | tinytext | YES | | NULL | |
| result_slclient | varchar(20) | YES | | NULL | |
| local_wlh | tinytext | YES | | NULL | |
| result_wlh | varchar(20) | YES | | NULL | |
| local_ofdplugin | tinytext | YES | | NULL | |
| result_ofdplugin | varchar(20) | YES | | NULL | |
| local_suwellread | tinytext | YES | | NULL | |
| result_suwellread | varchar(20) | YES | | NULL | |
| local_foxitofficesuite | text | YES | | NULL | |
| result_foxitofficesuite | varchar(20) | YES | | NULL | |
| local_topdesk | text | YES | | NULL | |
| result_topdesk | varchar(20) | YES | | NULL | |
| local_certaide | tinytext | YES | | NULL | |
| result_certaide | varchar(20) | YES | | NULL | |
| local_com-360-browser | tinytext | YES | | NULL | |
| result_com-360-browser | varchar(20) | YES | | NULL | |
| local_qaxbrowser | tinytext | YES | | NULL | |
| result_qaxbrowser | varchar(20) | YES | | NULL | |
| local_updater | tinytext | YES | | NULL | |
| result_updater | varchar(20) | YES | | NULL | |
| local_wwlocal | tinytext | YES | | NULL | |
| result_wwlocal | varchar(20) | YES | | NULL | |
| final | int(10) unsigned | YES | | NULL | |
| date | datetime | YES | | current_timestamp() | on update current_timestamp() |
+-------------------------+------------------+------+-----+---------------------+-------------------------------+
32 rows in set (0.001 sec)
MariaDB [xc]>