程序员人生网站导航

mysql查看表结构和表创建语命令

栏目：互联网时间：2014-10-08 08:00:00

1,desc tablename;

mysql> desc authors; +-------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------+--------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | email | varchar(100) | NO | UNI | NULL | | | name | varchar(100) | NO | | NULL | | +-------+--------------+------+-----+---------+----------------+ 3 rows in set

2,show create table tablename;

mysql> show create table authors; +---------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +---------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | authors | CREATE TABLE `authors` ( `id` int(11) NOT NULL AUTO_INCREMENT, `email` varchar(100) NOT NULL, `name` varchar(100) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `email` (`email`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 | +---------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set

3,select * from columns where table_name='表名'

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

------分隔线----------------------------

上一篇 leetcode - Palindrome Partitioning

下一篇 IOS消息推送流程

------分隔线----------------------------

最新技术推荐

1.cyou 非常适合 Z 世代企业家的三大理由 2阿里、京东类ChatGPT产品正在内测未来或将融入产品 3公会积极复工复产，2023直播行业有哪些新机遇？ 4第三届OpenHarmony技术大会展区亮点纷呈，全方位洞见智慧互联未来 5第三届OpenHarmony技术大会应用生态实践分论坛成功举办 6第三届OpenHarmony技术大会OS安全分论坛圆满举办 7第三届 OpenHarmony 技术大会：创新成果丰硕，共筑开源生态新未来