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
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
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
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
Yeah. I am moving data from mysql server to sql
server.
Because I have single quote in some strings, it
generated errors when I ran mysqldump scripts in sql
server to import data in.
i.e. strings Here's, Martin's ,... caused trouble.
Does that mean sql didn't recognize escaped single
quote?
Yeah. I am moving data from mysql server to sql
server.
Because I have single quote in some strings, it
generated errors when I ran mysqldump scripts in sql
server to import data in.
i.e. strings Here's, Martin's ,... caused trouble.
Does that mean sql didn't recognize escaped single
Thanks Jim. Great suggestions.
I will try both to see which one is better for my
case.
Appreciated your help.
Monet
--- Jim Grill [EMAIL PROTECTED] wrote:
Yeah. I am moving data from mysql server to sql
server.
Because I have single quote in some strings, it
generated errors when I ran