Re: mysql to cvs file to excel
| From: | Ruth Zhai | Date: | Mon, 24 Feb 2003 00:56:31 +0000 |
| Subject: | Re: mysql to cvs file to excel | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-25861@lists.php.net to get a copy of this message | ||
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" <Mark.Snijders@atosorigin.com>
To: <php-db@lists.php.net>
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
>
>