mysql怎么查看表结构和注释

MySQL查看表结构简单命令。一、简单描述表结构，字段类型desctabl_name显示表结构，字段类型，主键，是否为空等属性，但不显示外键。二、查询表中列的注释信息select*frominformation_schema.columnswheretable_schema='db'#表所在数据库andtable_name='tablename'#你要查的表三、只查询列名和注释selectcolumn_name,column_commentfrominformation_schema.columnswheretable_schema='db'andtable_name='tablename'四、#查看表的注释selecttable_name,table_commentfrominformation_schema.tableswheretable_schema='db'andtable_name='tablename'ps：二～四是在元数据表中查看，我在实际 *** 作中，常常不灵光，不知为什么，有了解的大侠请留印。五、查看表生成的DDLshowcreatetabletable_name

select t1.name,t2.name,t3.name,t4.name

from tb as t1

left join tb as t2 on t2.pid=t1.id and t2.pid=1

left join tb as t3 on t3.pid=t2.id and t3.pid=2

left join tb as t4 on t4.pid=t3.id and t4.pid=3

where pid=0

---