> Is there nothing you can do with > --fields-terminated-by=... > --fields-enclosed-by=... > --fields-optionally-enclosed-by=... > --fields-escaped-by=... > --lines-terminated-by=...
As I mentioned, those options **only** apply when using the "-T" option which creates a tab delimited dump file. That would be a cool option though. :-) There are a number programs that can assist with converting to and from MySQL if that's the goal. Regards, Jim Grill ----- Original Message ----- From: [EMAIL PROTECTED] To: Jim Grill Cc: Monet ; mysql Sent: Friday, September 24, 2004 1:59 PM Subject: Re: how to change mysqldump output txt file format? Jim - He needs to change the format because he isn't exporting from one MySQL database to another.... His destination database doesn't like the escaped single quotes. Here is the manual page for mysqldump: http://dev.mysql.com/doc/mysql/en/mysqldump.html Is there nothing you can do with --fields-terminated-by=... --fields-enclosed-by=... --fields-optionally-enclosed-by=... --fields-escaped-by=... --lines-terminated-by=... to get what you want from mysqldump? Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Jim Grill" <[EMAIL PROTECTED]> wrote on 09/24/2004 02:35:40 PM: > > Hello everyone, > > > > In mysqldump output txt file, all datetime, varchar, > > text fields value are surrounding by single quotes. Is > > there any way that the single quotes can be replaced > > by double quotes in the txt file? > > Furthermore, if you have a single quote in text field, > > it will automatically replaced by \'. But I like to > > keep it in the way it input. > > > > There is no way to change the use of single quotes in a standard dump. The > only time you have a choice is when you use the -T option, which creates a > tab or csv type dump files depending on options present on the command line. > You could use this option if you wanted. The only draw back is that > mysqdump -T must be run on the same machine as the server. > > However, why is the presents of escaped single quotes a problem? They are > only escaped to let MySQL know to treat them as literal single quotes and > not string delimiters. They do not actually get inserted into your table > with the slashes. > > Regards, > > Jim Grill > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >
