SELECT GROUP_CONCAT(COLUMN_NAME SEPARATOR ',') FROM
information_schema.COLUMNS
WHERE
TABLE_SCHEMA = 'feixmanagedb'
AND TABLE_NAME = 'encryptversiontbl';
MySQL 列名查询
最新推荐文章于 2024-07-07 12:29:28 发布
SELECT GROUP_CONCAT(COLUMN_NAME SEPARATOR ',') FROM
information_schema.COLUMNS
WHERE
TABLE_SCHEMA = 'feixmanagedb'
AND TABLE_NAME = 'encryptversiontbl';