问题描述
mysql查询除某一列外的所有列数据
set @t_name='t_gyzjz_ind_zzzxt_jk';
-- 拼接sql语句
set @sql=concat('insert into ',@t_name," select '202205' as statis_month",(SELECT REPLACE
( GROUP_CONCAT( COLUMN_NAME ), 'statis_month', '' )
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
TABLE_NAME = @t_name
AND TABLE_SCHEMA = 'api_gx'),' from ',@t_name,' where statis_month=(select max(statis_month) from ',@t_name,')');
-- 预处理语句
prepare stmt1 from @sql;
-- 执行预处理语句
execute stmt1;
-- 释放预处理语句
deallocate prepar stmt1;
解决方案:
使用mysql预处理语句
INFORMATION_SCHEMA.COLUMNS