SELECT
CONCAT('表名为 ', C.TABLE_NAME, ' 字段为 ', GROUP_CONCAT(C.COLUMN_NAME SEPARATOR ', ')) AS 'Table and Columns'
FROM
INFORMATION_SCHEMA.COLUMNS C
WHERE
C.TABLE_SCHEMA = 'aizuda'
AND C.TABLE_NAME IN ('pdd_token', 'pdd_user_token')
GROUP BY
C.TABLE_NAME;
mysql 查询 表名 +表字段的 字符串
于 2023-05-21 15:48:08 首次发布