//大表删除修改数据CREATEPROCEDUREp_del_rows()BEGINDECLARE v_rows INT;SET v_rows =1;WHILE
v_rows >0DODELETEFROM shop_info
WHERE
id >=9000AND id <=190000LIMIT5000;SELECTROW_COUNT()INTO v_rows;SELECTSLEEP(5);ENDWHILE;END;
mysql大表删除更新操作//大表删除修改数据CREATE PROCEDURE p_del_rows () BEGIN DECLARE v_rows INT; SET v_rows = 1; WHILE v_rows > 0 DO DELETE FROM shop_info WHERE id >= 9000 AND id <= 190000 LIMIT 5000; SELECT ROW_COUNT() INTO v_r