MySQL 查看表结构命令

逃离我推掉我的手 2022-05-15 15:46 276阅读 0赞

MySQL查看表结构有如下6种方式：

DESC 表名;
    SHOW COLUMNS FROM 表名;
    DESCRIBE 表名;
    SHOW CREATE TABLE 表名;
    USE INFORMATION_SCHEMA;
    SELECT * FROM columns WHERE table_name='表名'

现在有一张表 rbt\_role，使用以上每条语句查看一下该表的结构，结果显示在每条下面

1.      DESC rbt_role
    
    ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3M1NjYwZ3Q_size_16_color_FFFFFF_t_70][]
2.      SHOW COLUMNS FROM rbt_role
    
    ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3M1NjYwZ3Q_size_16_color_FFFFFF_t_70 1][]
3.      DESCRIBE rbt_role
    
    ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3M1NjYwZ3Q_size_16_color_FFFFFF_t_70 2][]
4.      SHOW CREATE TABLE rbt_role
    
    <table> 
     <tbody> 
      <tr> 
       <td> <p>Table</p> </td> 
       <td>Create Table</td> 
      </tr> 
      <tr> 
       <td>rbt_role</td> 
       <td> <p>CREATE TABLE `rbt_role` ( `id` int(20) NOT NULL AUTO_INCREMENT, `role_name` varchar(20) NOT NULL, `role_desc` varchar(30) DEFAULT NULL, `creation_time` datetime DEFAULT NULL, `update_time` datetime DEFAULT NULL, `yn` int(1) DEFAULT NULL, PRIMARY KEY (`id`), KEY `RROLE_ROLE_NAME_INDEX` (`role_name`), KEY `RROLE_ROLE_DESC_INDEX` (`role_desc`), KEY `RROLE_YN_INDEX` (`yn`)) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8</p> </td> 
      </tr> 
     </tbody> 
    </table>

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3M1NjYwZ3Q_size_16_color_FFFFFF_t_70]: /images/20220503/63ea65ed207340c19e446d80e9bba7b5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3M1NjYwZ3Q_size_16_color_FFFFFF_t_70 1]: /images/20220503/298d4c39934c43dfb2cf2364341fb292.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3M1NjYwZ3Q_size_16_color_FFFFFF_t_70 2]: /images/20220503/08e0de770c9e4a839afb3857f87cb738.png