MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: MYSQL Table Creation from exiting tables
Posted by: Muvendran narayanan
Date: February 06, 2015 12:41AM

THanks PHILL,

Now i need to select 28000 random rows from table named as students which consists of millions of records

If i do it with ORDER BY RAND() it takes long time
Is there any other method or query to select the 28000 random records very fast

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
MYSQL Table Creation from exiting tables
Muvendran narayanan
February 04, 2015 11:10PM
Re: MYSQL Table Creation from exiting tables
Phillip Ward
February 05, 2015 06:36AM
Re: MYSQL Table Creation from exiting tables
Muvendran narayanan
February 06, 2015 12:41AM
Re: MYSQL Table Creation from exiting tables
Rick James
February 06, 2015 03:54PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.