Re: Large table delete from ...

2002-05-21 Thread mos
At 01:22 AM 5/19/2002, you wrote: >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

Re: Large table delete from ...

2002-05-18 Thread Valics Lehel
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 hou