原标题：Mysql查询数据，并且分表再插入数据，储存过程源码解析
Mysql 查询数据，并且再分表插入数据
直接上代码：有用请支持一下：
drop procedure if exists insertt;
delimiter $$
create procedure insertt()
begin
declare a int default 1000;
declare flag int default 0;
declare article_id int(10);
declare s_list cursor for SELECT `id` as "article_id" FROM `div_article` ORDER BY `id` ASC LIMIT 0,1;
declare continue handler for not found set flag=1;
open swww.yii666.com_list;
fetch s_list into article_id;
while flag <> 1 do
set @tid = article_id%1000;
set @tname = CONCAT('`div_test',@tid,'`');
set @article_id = article_id;
set @title = (SELECT title FROM `div_article` WHERE id = @article_id) ;
set @sqlStr= CONCAT('INSERT INTO ',@tname,'(`id`,`title`) VALUES (',@article_id,', "',@title,&文章来源站点https://www.yii666.com/#39;")');
PREPARE stmt from @sqlStr;
EXECUTE stmt;
fetch s_list into articlewww.yii666.com_id;
e文章来源地址https://www.yii666.com/learning/mysql/220.htmlnd while;
close s_list;
end$$
delimiter;
call&nbs文章来源地址https://www.yii666.com/learning/mysql/220.htmlp;insertt();
