- 论坛徽章:
- 1
|
本帖最后由 visician 于 2013-04-09 20:40 编辑
这样写也不行,show errors还会报错:Error 1329 No data - zero rows fetched, selected, or processed- BEGIN
- declare done int default(0);
- DECLARE UserID varchar(10);
- DECLARE authors_cursor CURSOR FOR select User_ID from table1;
- DECLARE CONTINUE HANDLER FOR NOT FOUND SET done=1;
-
-
-
- step1:BEGIN
- OPEN authors_cursor;
-
- if done=1 THEN
- leave step1;
- end if;
- FETCH authors_cursor INTO UserID;
- insert_loop:LOOP
- if done=1 then
- leave insert_loop;
- end IF;
-
- FETCH authors_cursor INTO UserID;
- END loop insert_loop;
- END;
- CLOSE authors_cursor;
-
- END
复制代码 |
|