存储过程的定义：遍历一个列表

#创建存储过程
CREATE PROCEDURE useCursor()
BEGIN
declare tmpOrder int ;
declare rs CURSOR FOR  select id FROM order_original  where user_id="888888";
OPEN rs;
FETCH rs INTO tmpOrder;
WHILE ( tmpOrder is not null) DO
delete FROM order_original  where id = @tmpOrder;
FETCH rs INTO tmpOrder;
END WHILE;
CLOSE rs ;
END;
#调用存储过程
call useCursor();