SELECT
group_concat(column_name)
FROM
information_schema. COLUMNS
WHERE
TABLE_SCHEMA = 'db(库名)'
and TABLE_NAME='t_table(表名)'
—mysql中直接获取所有字段
方便快速构建查询字段
SELECT
group_concat(column_name)
FROM
information_schema. COLUMNS
WHERE
TABLE_SCHEMA = 'db(库名)'
and TABLE_NAME='t_table(表名)'
—mysql中直接获取所有字段
方便快速构建查询字段