比如要出现abcd库中的表:
SELECT
UPPER(table_name) ,
TABLE_COMMENT
FROM
information_schema. TABLES
WHERE
table_schema = 'abcd'
AND table_type = 'base table';
UPPER()函数就是转大写
SELECT
UPPER(table_name) ,
TABLE_COMMENT
FROM
information_schema. TABLES
WHERE
table_schema = 'abcd'
AND table_type = 'base table';
UPPER()函数就是转大写