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 grasp the progress by using the stored procedure to delete it. This is the sample code of MySQL cursor loop, so you can avoid frequent searches in the future.

If you use the in statement, it feels very slow and there is no result after running for a long time. You can grasp the progress by using the stored procedure to delete it. This is the sample code of MySQL cursor loop, so you can avoid frequent searches in the future.

If you use the in statement, it feels very slow and there is no result after running for a long time. You can grasp the progress by using the Stored Procedure deletion. This is the sample code of MySQL cursor loop to avoid frequent searches in the future, record.

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