drop PROCEDURE if EXISTS GetTotal;
#str_num,numbers of string array
#str_arr,array of strings
CREATE PROCEDURE GetTotal(IN str_num int,IN str_arr VARCHAR(10000))
BEGIN
declare idx int default 1;
declare total int default 0;
declare c int default 0;
#declare tablename varchar(50);
LOOP_LABLE:loop
select count(*) into c from (select SUBSTRING_INDEX(SUBSTRING_INDEX(str_arr, ' ', idx), ' ', -1)) as tablename;# where isNew=1;
#set tablename=SUBSTRING_INDEX(SUBSTRING_INDEX(str_arr, ' ', idx), ' ', -1);select tablename;
set total=total+c;
set idx=idx+1;
if idx>str_num THEN
leave LOOP_LABLE;
end if;
end loop;
select total;
END
call GetTotal(2,'Auto Ent');
本来是要折腾一个通过参数将多个表名传到存储过程去批量统计记录总数的,到了将参数转换成表名那一步就实现不了了,然后突然间又用不了这么做了,先mark it down吧。