MySQL查询除了某字段之外其余字段的值
SELECT
GROUP_CONCAT( column_name SEPARATOR ',' )
FROM
information_schema.COLUMNS
WHERE
column_name != '排除的字段'
AND table_name = '数据库表名' and table_schema = '数据库名';
可以查到除了某字段外的其余字段,但是
select (SELECT
GROUP_CONCAT( column_name SEPARATOR ',' )
FROM
information_schema.COLUMNS
WHERE
column_name != '排除的字段'
AND table_name = '数据库表名' and table_schema = '数据库名')
FROM '表名';
却拿不到想要的数据
为什么???????????????????????