mysql查看表結構和表創建語命令

1,desc tablename;

mysql> use information_schema;
Database changed
mysql> select * from columns where table_name='authors';  
+---------------+--------------+------------+-------------+------------------+----------------+-------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+-----------------+--------------+------------+----------------+---------------------------------+----------------+
| TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | ORDINAL_POSITION | COLUMN_DEFAULT | IS_NULLABLE | DATA_TYPE | CHARACTER_MAXIMUM_LENGTH | CHARACTER_OCTET_LENGTH | NUMERIC_PRECISION | NUMERIC_SCALE | CHARACTER_SET_NAME | COLLATION_NAME  | COLUMN_TYPE  | COLUMN_KEY | EXTRA          | PRIVILEGES                      | COLUMN_COMMENT |
+---------------+--------------+------------+-------------+------------------+----------------+-------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+-----------------+--------------+------------+----------------+---------------------------------+----------------+
| def           | zqad         | authors    | id          |                1 | NULL           | NO          | int       | NULL                     | NULL                   |                10 |             0 | NULL               | NULL            | int(11)      | PRI        | auto_increment | select,insert,update,references |                |
| def           | zqad         | authors    | email       |                2 | NULL           | NO          | varchar   |                      100 |                    300 | NULL              | NULL          | utf8               | utf8_general_ci | varchar(100) | UNI        |                | select,insert,update,references |                |
| def           | zqad         | authors    | name        |                3 | NULL           | NO          | varchar   |                      100 |                    300 | NULL              | NULL          | utf8               | utf8_general_ci | varchar(100) |            |                | select,insert,update,references |                |
+---------------+--------------+------------+-------------+------------------+----------------+-------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+-----------------+--------------+------------+----------------+---------------------------------+----------------+
3 rows in set

生活不易，碼農辛苦
如果您覺得本網站對您的學習有所幫助,可以手機掃描二維碼進行捐贈