Hi,
Try using,
SELECT * INTO OUTFILE 'tmp/music_mp3.txt' FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY ' " '
LINES TERMINATED BY ' \n '
FROM mp3;
Thanks
ViSolve DB Team
----- Original Message -----
From: "Shain Lee" <[EMAIL PROTECTED]>
To: "MySql" <mysql@lists.mysql.com>
Sent: Friday, January 05, 2007 11:05 AM
Subject: mysql data into CSV file.
Hi
For example , suppose i have a database - Music, and a table in it is mp3.
under mp3 there is more fields , like, id, artist, name , mp3_file...etc.
I wanted to get that info which has stored in relavent fields into a CSV
fle .
Can somebody help me to do that please ?
Can i do it mysql commands it self ?
Thank you,
Shaine.
Send instant messages to your online friends http://uk.messenger.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
