At 11:06 + 3/4/02, Amit Dilip Lonkar wrote:
>Hi
>
>How can I export data, from the database tables in Mysql, to a Comma
>Seperated File(CSV).
If you have the FILE privilege, you can use SELECT ... INTO OUTFILE.
If you don't, I have a Perl script that can export directly as CSV to a
file on t
Hi,
SELECT columns
INTO OUTFILE 'path/to/directory/file.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY "\n"
FROM table
for more info checkout:
http://www.mysql.com/doc/S/E/SELECT.html
cheers
Richard
At 11:06 04/03/2002 +, Amit Dilip Lonkar wrote:
>Hi
>
>How
Hi
How can I export data, from the database tables in Mysql, to a
Comma Seperated File(CSV).
Urgent
Amit Lonkar
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
