Hi all,
I'm trying to use a limit clause with delete, but it doesn't work at the moment (are there plans to add this - I could try to do up a patch ?).
eg.
delete from table where x='1' limit 1000;
Is there another way to approach this?
I'm trying to delete records through a webapp and if there are 500,000 records for example, I can't really leave the page open and expect it to finish...
-- Regards,
Chris Smith
Unit 2, 3 National Street, Rozelle, NSW 2039 Australia
Ph: +61 2 9555 5570 Fx: +61 2 9555 5571
email: info@xxxxxxxxxxxxxx web: http://www.interspire.com
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
