On 8 April 2010 11:55, Ian Barwick wrote:
> 2010/4/8 Thom Brown :
> > I couldn't find any discussion on this, but the request is quite
> > straightforward. Implement a LIMIT on DELETE statements like SELECT
> > statements.
> >
> > So you could write:
> >
> > DELETE FROM massive_table WHERE id <
2010/4/8 Thom Brown :
> I couldn't find any discussion on this, but the request is quite
> straightforward. Implement a LIMIT on DELETE statements like SELECT
> statements.
>
> So you could write:
>
> DELETE FROM massive_table WHERE id < 4000 LIMIT 1;
>
> This would allow deletions in smal
I couldn't find any discussion on this, but the request is quite
straightforward. Implement a LIMIT on DELETE statements like SELECT
statements.
So you could write:
DELETE FROM massive_table WHERE id < 4000 LIMIT 1;
This would allow deletions in smaller batches rather than waiting
poten
