mysql 批量删除
- 作者: 寻找我的弱点
- 来源: 51数据库
- 2022-08-17
CREATE PROCEDURE del_line()
BEGIN
DECLARE count_line INT;
/** 先删除索引提高删除速度*/
ALTER TABLE `test_road_1`.`lebp_logistics_line`
DROP INDEX index_carrier_id,
DROP INDEX index_state,
DROP INDEX index_leave_city,
DROP INDEX index_leave_city_area,
DROP INDEX index_arrive_city,
DROP INDEX index_arrive_city_area,
DROP INDEX index_mock_attachment;
SELECT COUNT(*) INTO count_line FROM lebp_logistics_line;
WHILE count_line > 0 DO
DELETE FROM lebp_logistics_line LIMIT 10000 ;
COMMIT ;
SET count_line = count_line - 10000 ;
END WHILE ;
END
推荐阅读
