[ 笔记列表 ]
所属分类:MySQL
浏览:131
内容:
语句1、 ## 根据数据库查询表名和表注释 SELECT TABLE_NAME AS tableName, TABLE_COMMENT AS tableComment FROM information_schema.`TABLES` WHERE TABLE_SCHEMA = 'test_db'; 语句2、 ## 根据数据库和表查询表字段名和字段注释 SELECT column_name, data_type, column_comment, IF(column_key='PRI','是','否') AS '主键唯一', IF(IS_NULLABLE='NO','是','否') AS '非空', column_type FROM information_schema.COLUMNS WHERE table_name = "test_table" AND table_schema = 'test_db';
链接:
|