mysql 查看錶結構的指令

標籤：mysql 指令 表結構

1. desc tablenamename;
   

2. describe tablename;

3. show columns tablename;

4. show create table tablename;

   1,2,3展示的是

+-------------+-------------+------+-----+---------+----------------+
| Field       | Type        | Null | Key | Default | Extra          |
+-------------+-------------+------+-----+---------+----------------+
| id          | int(11)     | NO   | PRI | NULL    | auto_increment |
| uid         | int(11)     | NO   |     | 0       |                |
| create_time | int(11)     | NO   |     | NULL    |                |
| grade       | varchar(10) | YES  |     | NULL    |                |
+-------------+-------------+------+-----+---------+----------------+

第4中是把建立表的語句打出來，如下；

+--------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| t_test | CREATE TABLE `t_test` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT ‘ID‘,
  `uid` int(11) NOT NULL DEFAULT ‘0‘ COMMENT ‘使用者id‘,
  `create_time` int(11) NOT NULL COMMENT ‘發放時間‘,
  `grade` varchar(10) DEFAULT NULL COMMENT ‘等級‘,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8               |

mysql 查看錶結構的指令