我call一个存储过程的时候 出现了:1932 No data - zero rows fetched, selected, or processed.
The code of my stored procedures goes like this, maybe someone will be able to help me find a workaround: begin
declare name varchar(70);
declare insert_name cursor for select distinct s_name from supplier_name; delete from supplier_name where s_name is null or s_name ='';
open insert_name;
fetch insert_name into name;
while(name is not null) do insert into supplier_data_copy(s_name) select distinct s_name from supplier_name where s_name not in ( select s_name from supplier_data);
fetch insert_name into name;
end while;
close insert_name;
truncate supplier_name;
end 这个过程的目的是:把supplier_name里面的s_name (在supplier_data里面没有这个s_name的话)就插入到 supplier_data_copy去。我用的是mysql-5.1.41-win32.msi
还有,当我单独用insert into supplier_data_copy(s_name) select distinct s_name from supplier_name where s_name not in ( select s_name from supplier_data); 这个的时候也是0行影响的。然后我改成insert into supplier_data_copy(s_name) select distinct s_name from supplier_name where s_name not in ( select s_name from supplier_datan); 这个却能insert的,2句的不同是因为一个是supplier_data,另外一个是supplier_datan,supplier_datan里面只有supplier_data的1000条数据,supplier_data里面有60多万条
The code of my stored procedures goes like this, maybe someone will be able to help me find a workaround: begin
declare name varchar(70);
declare insert_name cursor for select distinct s_name from supplier_name; delete from supplier_name where s_name is null or s_name ='';
open insert_name;
fetch insert_name into name;
while(name is not null) do insert into supplier_data_copy(s_name) select distinct s_name from supplier_name where s_name not in ( select s_name from supplier_data);
fetch insert_name into name;
end while;
close insert_name;
truncate supplier_name;
end 这个过程的目的是:把supplier_name里面的s_name (在supplier_data里面没有这个s_name的话)就插入到 supplier_data_copy去。我用的是mysql-5.1.41-win32.msi
还有,当我单独用insert into supplier_data_copy(s_name) select distinct s_name from supplier_name where s_name not in ( select s_name from supplier_data); 这个的时候也是0行影响的。然后我改成insert into supplier_data_copy(s_name) select distinct s_name from supplier_name where s_name not in ( select s_name from supplier_datan); 这个却能insert的,2句的不同是因为一个是supplier_data,另外一个是supplier_datan,supplier_datan里面只有supplier_data的1000条数据,supplier_data里面有60多万条
insert into supplier_data_copy(s_name)
select distinct s_name from supplier_name a
left join supplier_data b on a.s_name=b.s_name where b.s_name is null