方式一:
SELECT COLUMN_NAME FROM information_schema.COLUMNS WHERE TABLE_NAME = '表名';
方式二:
SELECT GROUP_CONCAT(COLUMN_NAME SEPARATOR ",") FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = '库名' AND TABLE_NAME = '表名';
方式一:
SELECT COLUMN_NAME FROM information_schema.COLUMNS WHERE TABLE_NAME = '表名';
方式二:
SELECT GROUP_CONCAT(COLUMN_NAME SEPARATOR ",") FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = '库名' AND TABLE_NAME = '表名';