delimiter $create PROCEDURE phoneDeal()BEGINDECLARE id varchar(64); -- idDECLARE phone1 varchar(16); -- phoneDECLARE password1 varchar(32); -- 密码DECLARE name1 varchar(64); -- id-- 遍历数据结束标志DECLARE done INT DEFAULT FALSE;-- 游标DECLARE cur_account CURSOR FOR select phone,password,name from account_temp;-- 将结束标志绑定到游标DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;-- 打开游标OPEN cur_account;-- 遍历read_loop: LOOP-- 取值 取多个字段FETCH NEXT from cur_account INTO phone1,password1,name1;IF done THENLEAVE read_loop;END IF;-- 你自己想做的操作insert into account(id,phone,password,name) value(UUID(),phone1,password1,CONCAT(name1,'的家长'));END LOOP;CLOSE cur_account;END $
