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]