## 簡單查詢表結構 SQL: ``` desc [table] ``` 示例: ``` MySQL [database]> desc zc_action_log; +----------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+--------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | module | varchar(20) | NO | MUL | NULL | | | target_id | int(11) | NO | MUL | 0 | | | update_time | int(11) | NO | | NULL | | +----------------+--------------+------+-----+---------+----------------+ ``` ## 查詢表創建語句 SQL: ``` SHOW CREATE TABLE [table] ``` 示例: ``` MySQL [database]> show create table zc_company_description\G; *************************** 1. row *************************** Table: zc_company_description Create Table: CREATE TABLE `zc_company_description` ( `id` int(11) NOT NULL AUTO_INCREMENT, `content` text NOT NULL COMMENT '內容', `create_time` int(11) NOT NULL, `update_time` int(11) NOT NULL, `delete_time` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='公司萬用描述信息' ``` 帶`\G`結尾鍵值對展示 ## show tables 擴展,顯示表注釋 SQL: ``` select table_name, table_comment from information_schema.tables where table_schema = '數據庫'; ``` 示例: ``` MariaDB [zcsb]> select table_name, table_comment from information_schema.tables where table_schema = 'zcsb'; +------------------------+----------------------------------------------------------------------------------+ | table_name | table_comment | +------------------------+----------------------------------------------------------------------------------+ | zc_preset_reason | 審核預設理由 | | zc_company_description | 公司萬用描述信息 | | zc_action_log | 客戶信息變更日志表，可作為時間軸的一部分數據 | | zc_userinfo_record | 跟進記錄 | | zc_admin_roles | 權限角色表 (organization_range字段對應zj_admin_group_organization的id) | | zc_major_level | 專業級別 | | zc_userinfo | 職稱申報 | | zc_education | 教育信息表 | | zc_company | 單位、公司信息 | | zc_major | 技術專業 | | zc_userinfo_audit | 資料審核表 | | zc_major_area | 申報區域 | | zc_work_history | 工作經歷 | | zc_achievement | 任現職后主要專業技術工作業績 | | zc_current_major | 現任專業技術 | | zc_qualification | 職業資格證 | +------------------------+----------------------------------------------------------------------------------+ ```