Dear all, I have some large MySQL tables and II want to delete for example month 2-2002 entirelly from an sql table.
I use now ... delete from table_name where year(data)=2002 and month(data)=2; I have almost 25.000.000 row and something like 7-8 mil is from month 2. Seems to make it for 2 hours and it's very much as time, I need other tables as well to clean up and then need to stop too much from clients the database. Can be do this in other way? Also if there a possibilities to export and delete this records?? Regards, Valics Lehel --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
