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
