Editor

Hello. I have an SQL database that needs editing. I have to delete millions of lines from it.

Whats the quickets way to do this, is there a way to delete from line X to line Y etc?

Thanks,
BlueEew.

 

If there is an index that increments, you can run a simple delete command.

Something like:
DELETE FROM my_table WHERE id > '1200' AND id < '240000';

If you don't care what the increment is on, you should repair the table afterwards to clear out all the extra overhead.

 

Luckly they we're all needed to be replaced, so I used a simple line replacment and it worked.