create PROCEDURE phoneDeal()
BEGIN
DECLARE name1 varchar(32); -- 密码
DECLARE pwd1 varchar(64); -- id
-- DECLARE id int(11);
-- 遍历数据结束标志
DECLARE done INT DEFAULT FALSE;
DECLARE flag int DEFAULT FALSE;
-- 游标
DECLARE cur_account CURSOR FOR select name,pwd from us;
-- 将结束标志绑定到游标
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
-- 打开游标
OPEN cur_account;
-- 遍历
read_loop: LOOP
-- 取值 取多个字段
FETCH NEXT from cur_account INTO name1,pwd1;
IF done THEN
LEAVE read_loop;
END IF;
-- 你自己想做的操作
IF (select t.id from user_t t where t.password = pwd1 and t.user_name = name1) is null THEN
insert into user_t(user_name,password,age) value(name1,pwd1,100);
END IF;
END LOOP;
CLOSE cur_account;
END;
CALL phoneDeal();