Atle, Thank you for your help
Mikhail Berman Ives Inc (508)476-7007 ext.27 [EMAIL PROTECTED] -----Original Message----- From: Atle Veka [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 17, 2005 1:16 PM To: Berman, Mikhail Cc: mysql@lists.mysql.com Subject: Re: Is there a way SELECT ... INTO OUTFILE 'filename' export_options': http://dev.mysql.com/doc/mysql/en/select.html The 'export_options' are the same as this syntax: http://dev.mysql.com/doc/mysql/en/load-data.html That may work for you. Atle - Flying Crocodile Inc, Unix Systems Administrator On Tue, 17 May 2005, Berman, Mikhail wrote: > Hello everyone, > > I am looking for a way to dump a number of tables from mysql Ver 14.7 > Distrib 4.1.9, for sun-solaris2.8 (sparc) into tabulated (csv) files > with tables's column names being on the top of each data column, > something like: > > > ID Column Name 1 Column Name 2 > 1 Data 1.1 Data 2.1 > 2 Data 2.1 Data 2.2 > > > I have done some research in manual and archives, looking for ways to > use "mysqldump", "mysqlimport" , or "Select INTO OUTFILE..", but did > not find a solution, yet. > > Your help is appreciated, > > Mikhail Berman > Ives Inc > (508)476-7007 ext.27 > [EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]