Re: [PHP-DB] mysql to cvs file to excel

2003-02-23 Thread Ruth Zhai 
This is what I use to generate a comma delimited csv file:

   $sql = "SELECT * FROM table INTO OUTFILE 'file.csv'"
 ." FIELDS TERMINATED BY \',\'"
 ." ENCLOSED BY \'\"\'";

Hope this helps.

Ruth


 
- Original Message - 
From: "Snijders, Mark" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 21, 2003 8:59 PM
Subject: [PHP-DB] mysql to cvs file to excel


> hello,
> 
> does anybody know if it's possible (without php)
> 
> to export data from mysql to a cvs file, so i can import it in excel???
> 
> so is it possible, and if yes.. how?
> 
> thanks kinds regards,
> 
> Mark Snijders
> 
> 
> 
> 
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 
> 



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] mysql to cvs file to excel

2003-02-21 Thread Bruno Pereira 
I had the some problem and someone told me this

"What is your problem exactly?

Have you investigated the MySQL manual under:
LOAD DATA INFILE
SELECT ... INTO OUTFILE ?"

And it realy helped.

Cumprimentos

Bruno Pereira
[EMAIL PROTECTED]

-Original Message-
From: Snijders, Mark [mailto:[EMAIL PROTECTED]]
Sent: sexta-feira, 21 de Fevereiro de 2003 9:59
To: [EMAIL PROTECTED]
Subject: [PHP-DB] mysql to cvs file to excel


hello,

does anybody know if it's possible (without php)

to export data from mysql to a cvs file, so i can import it in excel???

so is it possible, and if yes.. how?

thanks kinds regards,

Mark Snijders





-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] mysql to cvs file to excel

2003-02-21 Thread Snijders, Mark 
hello,

does anybody know if it's possible (without php)

to export data from mysql to a cvs file, so i can import it in excel???

so is it possible, and if yes.. how?

thanks kinds regards,

Mark Snijders





-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php