You need to have mySQL Workbench
1
2
3
4
5
6
7
--execute
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
select * from tablename;
COMMIT;
--when appear to grid select all, rclick > delete
origin - https://www.pipiscrew.com/?p=16588 mysql-delete-uncommitted-rows