By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,725 Members | 1,048 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,725 IT Pros & Developers. It's quick & easy.

How to Extract only the starting data?

P: 58
Hi everyone,

I have a problem with my Mysql data. I have 2,95,67,456 lines of data which is too much and if I run this in MYSQL front-end it is telling "OUT OF MEMORY". Any way with my collegues system I have got the runned data and I have copied it to my Frontend, now it works. But my problem is if I am extracting particular data from that it is telling "ACCESS VIOLATION" so I have decided to extract only data from the first 1,00,000 lines, my question is"Is there any command in Mysql to extract data starting from 0 and ending at 1,00,000"if so can anyone tell me about that as soon as possible.

I have used SELECT ***** FROM **** WHERE **** LIKE *****(If we give this it will select the mentioned data from the whole database)
But, I want only the data from the first 1,00,000 lines

Thanks in advance

Regards
Siva
Dec 18 '08 #1
Share this Question
Share on Google+
1 Reply


mwasif
Expert 100+
P: 801
Use LIMIT 0,100000
Dec 18 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.