mysql procedure

proc_demo.proc

DELIMITER ;;
CREATE DEFINER=`root`@`%` PROCEDURE `proc_update`(in type int,in start int,in end int)
begin
set @start=start;
set @end=end;
while @start<@end
do
update tbl_material set file_type = type where id = @start;
set @start=@start+1;
end while;
end;;
DELIMITER ;