Hi. I am building an application where users have the posibility to export some information from a mysql table(information is return by a select command) into a file(probably a csv).
I read some tutorials I founded on the net , but there the saving part is done by mysql server and I'm not interested in this solution because the users are conected to a remote mysql server.
The problem I have is that I can save the select if returns a small amount of rows. but some queries returns 200k+ rows and I want to keep the memory as much free as I can.
Is there any trick or any way I can read information from a large table?