delimiter //
drop procedure if exists procedure_ngg_pic_meta//
create procedure procedure_ngg_pic_meta()
begin
declare filename varchar(250) default '' ; /*文件名*/
declare style_type varchar(250) default '' ;/*风格*/
declare brand varchar(100) default '' ; /*品牌*/
declare review mediumtext default '' ;/*编辑评论*/
declare pid bigint(19) default '0' ;/*定义pid*/
declare rs cursor for select a.filename from tb_pictures a;/*申明游标*/
declare continue handler for sqlstate '02000' set filename = null; /*当文件名为null时跳出循环*/
open rs;/*打开游标*/
fetch rs into filename; /*取得文件名*/
while ( filename is not null) do
/*开始遍历*/
/*主代码开始*/
select a.pid into pid from wp_ngg_pictures a where a.filename=filename;/*找到pid*/
select b.style_type,b.brand,b.review into style_type,brand,review from tb_pictures b where b.filename=filename;
insert into wp_nggcf_field_values (pid,fid,field_value,ngg_type,dateadded)
values( pid,6,style_type,1,now());
insert into wp_nggcf_field_values(pid,fid,field_value,ngg_type,dateadded)
values(pid,5,brand,1,now());
insert into wp_nggcf_field_values(pid,fid,field_value,ngg_type,dateadded)
values(pid,7,review,1,now());
/*主代码结束*/
fetch rs into filename ;
end while; /* 遍历结束*/
close rs;/*关闭游标 */
end //
delimiter ;