通用分表存储过程(二)
_',
LPAD(c_table, 4, 0),
' select * from item_records_0000 where id = ');
PREPARE STMT_I FROM @SQL_INSERT;
SET @SQL_DELETE =
CONCAT('DELETE FROM bbc_item_record_',
LPAD(c_table, 4, 0),
' where id = ');
PREPARE STMT_D FROM @SQL_DELETE;
--如果数据已经存在，则先delete在insert
if @v_row>0 then
EXECUTE STMT_D using @vv_id;
DEALLOCATE PREPARE STMT_D;
end if;
EXECUTE STMT_I using @vv_id;
DEALLOCATE PREPARE STMT_I;
end if;
set ii=i+1;
if mod(i,100)=0 then commit;
end if;
until v_exit=1
end repeat;
close c_ids;
commit;
end;
//
call sp_xf_add_item()