MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: split file according to count
Posted by: Keith Larson
Date: February 24, 2014 02:42PM

With a script you could automate this.

But the basic concept is find your ranges and then write into outfile and use a limit

SELECT * FROM tbl LIMIT 5,10; # Retrieve rows 6-15
https://dev.mysql.com/doc/refman/5.6/en/select.html
https://dev.mysql.com/doc/refman/5.6/en/select-into.html

Just trying to help....

http://anothermysqldba.blogspot.com

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


Subject
Written By
Posted
split file according to count
Meenakshi Pant
February 24, 2014 05:14AM
Re: split file according to count
Keith Larson
February 24, 2014 02:42PM


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.