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

Reply via email to