设置 set names utf8; (如果你使用是gbk 请设置为gbk)
例如执行 sql 文件
set names utf8;
use record;
drop procedure if exists guideCal;
delimiter //
create procedure guideCal()
BEGIN
declare i int default 1;
declare d int default 1;
set @daypre = '2019-01-';
set @sd = 17;
set @se = 18;
set d = @sd;
while d >= @sd and d < @se do
if d < 10 then
SET @query_date = concat(@daypre,'0',d);
else
SET @query_date = concat(@daypre,d);
end if;
select @query_date;
set i = 40;
while i <= 40 do
set @n = i;
SET @task_name = concat('NewMain_1_1_',@n);
SET @sql_texta = concat('select count(*) as ',@task_name,' from task where time like \'%',@query_date,'%\' and Param10=\'',@task_name,'\' and Param11=\'接受任务\'');
select @sql_texta;
PREPARE stmta FROM @sql_texta;
EXECUTE stmta;
DEALLOCATE PREPARE stmta;
set i = i + 1;
end while;
set d = d + 1;
end while;
END //
call guideCal()