Page 1 of 1

mysql to CSV (Excel)

Posted: Mon Aug 13, 2007 1:14 am
by myharshdesigner
how to get data from mysql to CSV (Excel) ?

Posted: Mon Aug 13, 2007 1:34 am
by Christopher
Take a look at the "SELECT * INTO OUTFILE 'file_name' export_options FROM" syntax.

file:///c:/docs/mysql/manual_SQL_Syntax.html#SELECT

Posted: Mon Aug 13, 2007 1:53 am
by myharshdesigner
arborint wrote:Take a look at the "SELECT * INTO OUTFILE 'file_name' export_options FROM" syntax.

file:///c:/docs/mysql/manual_SQL_Syntax.html#SELECT

i just need to do it in PHP

so i need a simple php script .

how to import data into excel data

Posted: Mon Aug 13, 2007 5:49 am
by superdezign
myharshdesigner wrote:i just need to do it in PHP

so i need a simple php script .

how to import data into excel data
Beggars can't be choosers. :P

What have you tried to this extent? It sounds like the smartest method to get data from MySQL to CSV is to cut out the middleman.