MySQL cursor loop example

MySQL cursor loop example if the in statement is used, it feels very slow and there is no result after running for a long time. You can grasp the progress by deleting the stored procedure. This is the sample code of MySQL cursor loop, avoid frequent searches and record them later. Www.2cto.com create definer = 'root' @ '%' PROCEDURE 'bi '. 'Clean _ data' () reads SQL DATABEGIN declare v_imei varchar (128); declare stop int default 0; declare cur cursor for (select imei from bi. tmp_imei); declare continue handler for sqlstate '000000' SET stop = 1; OPEN cur; FETCH cur INTO v_imei; WHILE stop <> 1 DO delete from bi. tmp_dt_fee_user_info where imei = v_imei; FETCH cur INTO v_imei; end while; CLOSE cur; END