---------- Forwarded message ---------- From: Jake Peavy <[EMAIL PROTECTED]> Date: Jan 4, 2007 10:48 PM Subject: Re: mysql data into CSV file. To: Shain Lee <[EMAIL PROTECTED]>
On 1/4/07, Shain Lee <[EMAIL PROTECTED]> wrote:
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 ?
You could do with with SELECT .... INTO OUTFILE as outlined at http://dev.mysql.com/doc/refman/5.0/en/select.html#id3041795 Or you could make use of the new CSV storage engine http://dev.mysql.com/doc/refman/5.0/en/csv-storage-engine.html (forgot the bloody list...) -- -jp Switzerland isn't really neutral. They just haven't figured out what side Chuck Norris is on yet.
