Reg: Selecting particular data from a long data

[sivadhanekula]

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

[Chrisbob]

Try this Import Access tool - Navicat . It has schedule Import feature too. I think it's suitable for your case.

[r035198x]

Have a read at LIMIT and OFFSET.