- SELECT
- a.TABLE_NAME,
- a.TABLE_COMMENT,
- b.COLUMN_NAME,
- b.COLUMN_TYPE,
- b.COLUMN_COMMENT
- from
- information_schema.TABLES a,
- INFORMATION_SCHEMA.columns b
- where
- b.TABLE_NAME = a.TABLE_NAME
- and a.TABLE_SCHEMA = 'internet_hospital'
- and COLUMN_COMMENT like '%不接单%'
运行结果
