Re: Issue with delete

On 24/06/2021 16.48, Guillaume Lelarge wrote:
> Le jeu. 24 juin 2021 à 16:02, Radoulov, Dimitre <cichomitiko(at)gmail(dot)com
> <mailto:cichomitiko(at)gmail(dot)com>> a écrit :
>
>
>> Am 24.06.21 um 11:08 schrieb Rohit Rajput:
>> Good day everyone,
>>
>> I have few tables where i need to delete above 50 million rows
>> each. Since i dont want to delete them all in one shot and block
>> my table for extended time, i am trying to use limit with delete
>> but its giving me error every time. May i please get some
>> assistance here? Thanks
>>
>> Here is what i am running:
>>
>> delete from mytable where id in (select id from mytable where
>> condition=true limit 1000);
>>
>
> Wouldn't "delete from mytable where condition=true limit 1000" be
> sufficient?
>
>
>
> That syntax doesn't exist.

I should have tried the statement before asking, thanks!
I got confused by other databases (used it on Db2).

Best regards
Dimitre