Re: MySQL big table process

Try LIMIT in the select Plamen Slavov wrote:

Hi guys, I have a big MySQL table - about 300MB I want to get all the records from the table, make certain transformations and write them to a text file (i can not use "select into outfile...) the problem is when i type "select * from <table name>" the server hangs is there a way that i can select 1 record at a time or something similar, which would not put so much pressure on the server, but i still will get every record from the table Thanks ---------------------------------------------------------------------------------- Visit our site at http://eshop.bg