MySQL cursor loop example _ MySQL-mysql tutorial

MySQL cursor loop example bitsCN.com

MySQL cursor loop example

If you use the in statement, it feels very slow and there is no result after running for a long time. you can use the stored procedure to delete it.

Progress. this is the sample code of MySQL cursor loop. it can be recorded frequently in the future.

Create definer = 'root' @ '%' PROCEDURE 'bi'. 'clean _ data '()

READS SQL DATA

BEGIN

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 '200' 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

BitsCN.com