SQL RB AND VS

[Christian - ChrisKatDev.com]

Hi Ruslan,

I have 500,0000 record in database.
Where I want delete without limit, I have a crash (database diagnose : ok)

I have tried :
delete from dicowords where recid in (select recid from dicowords where reciddictionary = 4 ORDER BY recid limit 1000)

 but I have this error...
15:28:50 Kernel error: 0x71000. line 1:93: expecting ')', found 'ORDER'

??

Christian

Le 25 févr. 2012 à 15:03, Ruslan Zasukhin a écrit :

> On 2/25/12 3:13 PM, "Christian - ChrisKatDev.com"
> <christian at chriskatdev.com> wrote:
> 
>> hello,
>> 
>> why this request don't work :
>> delete from dicowords where recid in (select recid from dicowords where
>> reciddictionary = 4 limit 1000)
> 
> You want delete ANY  first 1000 records?
> 
> ANY because you not specify ORDER BY ... So you can get random records in
> this set ...
> 
> Well, I'd say - first 1000 records in their physical order in table ...
> 
> 
> -- 
> Best regards,
> 
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
> 
> Valentina - Joining Worlds of Information
> http://www.paradigmasoft.com
> 
> [I feel the need: the need for speed]
> 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20120225/d416e48b/attachment.html>