> 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]
