一个同事让我帮写的SQL,不一定优质,但应该能用。
SELECT
t1.TABLE_NAME,
t1.TABLE_COMMENT,
CONCAT(
'select ',
GROUP_CONCAT(
CONCAT(
t2.COLUMN_NAME,
' \'',
t2.COLUMN_COMMENT,
'\''
)
),
' from ',
t1.TABLE_NAME,
';'
) AS SQLTEXT
FROM
information_schema.`TABLES` t1,
information_schema.`COLUMNS` t2
WHERE
t1.TABLE_NAME = t2.TABLE_NAME
AND t1.TABLE_SCHEMA = '库名'
GROUP BY
t1.TABLE_NAME;