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</pre>
原创声明:本文系作者授权腾讯云开发者社区发表,未经许可,不得转载。
如有侵权,请联系 cloudcommunity@tencent.com 删除。
原创声明:本文系作者授权腾讯云开发者社区发表,未经许可,不得转载。
如有侵权,请联系 cloudcommunity@tencent.com 删除。