问题描述

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