Home  >  Article  >  Database  >  What are the commands to view table structure in MySQL?

What are the commands to view table structure in MySQL?

一个新手
一个新手Original
2017-09-08 11:12:412692browse

MySQL 查看表结构简单命令。 
一、简单描述表结构,字段类型desc tabl_name;
显示表结构,字段类型,主键,是否为空等属性,但不显示外键。
二、查询表中列的注释信息
select * from information_schema.columns where table_schema = 'db'  #表所在数据库
and table_name = 'tablename' ; #你要查的表
三、只查询列名和注释
select  column_name,
 column_comment from information_schema.columns where table_schema ='db'  and
 table_name = 'tablename' ;
四、#查看表的注释
select table_name,table_comment from information_schema.tables  where table_schema = 'db' and table_name ='tablename'
ps:二~四是在元数据表中查看,我在实际操作中,常常不灵光,不知为什么,有了解的大侠请留印。
五、查看表生成的DDL  show create table table_name;

The above is the detailed content of What are the commands to view table structure in MySQL?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn