How to generate .csv files with data from mysql ?

[tanyali]

using php, I wanna to get .csv files with data selected out from mysql.

who knows, please help. thanks first. .~_~.


Tanya

[pbmods]

Heya, tanyali.

Try using a SELECT ... INTO OUTFILE query.

[nallaraju]

hi folks,
i am able to get csv file for 1000 records. my problem is i need generate csv file for large data means around 20,000 records for this its exceeds max execution time. so i need some more optimization for data anybody help me in this i am very thankful.

[pbmods]

Heya nallaraju. Welcome to TSDN!

i am able to get csv file for 1000 records. my problem is i need generate csv file for large data means around 20,000 records for this its exceeds max execution time.

You could increase your max execution time directive (in php.ini for example if you use PHP).

Alternatively, you can use LIMIT to only output 1000 entries at a time.

[mwasif]

If you don't have access to php.ini then you can use set_time_limit() to increase execution time in PHP script. Sometimes it is beneficial to use mysql_unbuffered_query() instead of mysql_query() for huge data.

Take a look at this to use generate csv using PHP.