Thanks Garth. Actually Im trying to change the delimiter in the context of running a sql file from the command line - so in this case, I would want to change from tab to csv
mysql -h db#-reports.adz -u readonly -p < script.sql > output.csv ads12 -----Original Message----- From: Garth Webb [mailto:[EMAIL PROTECTED] Sent: Monday, February 23, 2004 5:01 PM To: [EMAIL PROTECTED] Subject: Re: Changing default delimiter I'm not sure in what context you want to change the delimiter, but here's the doc page on the LOAD DATA command which shows how to terminate (a.k.a. delimit) fields with different characters: http://www.mysql.com/doc/en/LOAD_DATA.html On Mon, 2004-02-23 at 13:53, David Perron wrote: > Greetings - > Been scouring the docs for this all day and I come up with nothing for > 'delimiter' - Id like to change the default delimiter in mysql to something > other than tab. > Is there a command to do this, and what are the options? > > Thank you! > > David > > -- |- Garth Webb -| |- [EMAIL PROTECTED] -| -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]