Re: Problem with rownum

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Thu, 13 Jan 2005 16:07:48 -0800
Message-ID: <41e70d48$2_1@127.0.0.1>

Andy Hassall wrote:

> On Thu, 13 Jan 2005 14:27:04 -0800, DA Morgan <damorgan_at_x.washington.edu>
> wrote:
>
>

>>Graeme D wrote:
>>
>>
>>>I don't understand why oracle doesn't have something like LIMIT x,x liek 
>>>there is in MySQL... any ideas?
>>
>>I don't understand why MySQL doesn't have full relational integrity and
>>the ability to perform transactional recovery ... any ideas?

>
>
> Yes it does, and yes it can. Perhaps you're still only considering the
> features of older versions, or haven't read the manual recently?
>
> A more helpful reply would be to point out how rownum in Oracle is determined,
> i.e. it's done before a sort, so an equivalent to MySQL's limit would involve a
> sorted subquery.

Are you using the obfuscation toolkit? How in MySQL can you recover a corrupt database at the transaction level? I may be behind by the latest release but not more than that.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---

Received on Thu Jan 13 2005 - 18:07:48 CST