SELECT C.`TABLE_SCHEMA`, C.`TABLE_NAME`, C.`COLUMN_NAME`, C.`COLUMN_COMMENT` FROM t_bims_areamanagement.`COLUMNS` C WHERE TABLE_NAME='TT' AND COLUMN_NAME='QQ'
SELECT C.`TABLE_SCHEMA`, C.`TABLE_NAME`, C.`COLUMN_NAME`, C.`COLUMN_COMMENT` FROM t_bims_areamanagement.`COLUMNS` C WHERE TABLE_NAME='t_bims_areamanagement' AND COLUMN_NAME='m_id'
information_schema是mysql自带的数据库, SELECT C.`TABLE_SCHEMA`, C.`TABLE_NAME`, C.`COLUMN_NAME`, C.`COLUMN_COMMENT` FROM information_schema.`COLUMNS` C where table_schema='表所在数据库名称' and table_name='t_bims_areamanagement';
那个我的就应该这样?SELECT C.`TABLE_SCHEMA`, C.`TABLE_NAME`, C.`COLUMN_NAME`, C.`COLUMN_COMMENT` FROM t_bims_areamanagement.`COLUMNS` C;
提示 Table 't_bims_areamanagement.columns' doesn't exist
WHERE TABLE_NAME='TT' AND COLUMN_NAME='QQ'
WHERE TABLE_NAME='t_bims_areamanagement' AND COLUMN_NAME='m_id'
SELECT C.`TABLE_SCHEMA`, C.`TABLE_NAME`, C.`COLUMN_NAME`, C.`COLUMN_COMMENT` FROM information_schema.`COLUMNS` C where table_schema='表所在数据库名称' and table_name='t_bims_areamanagement';