突然需要这么一个查询,找了一会,记录一下
转载地址https://www.cnblogs.com/a2b1/p/7352662.html
SELECT GROUP_CONCAT(COLUMN_NAME SEPARATOR ",") FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA = 'db_name' AND TABLE_NAME = 'table_name'
突然需要这么一个查询,找了一会,记录一下
转载地址https://www.cnblogs.com/a2b1/p/7352662.html
SELECT GROUP_CONCAT(COLUMN_NAME SEPARATOR ",") FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA = 'db_name' AND TABLE_NAME = 'table_name'