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.
For instances,
--
-- Dumping data for table 'week'
--
INSERT INTO week VALUES ('2004-03-23
10:13:00','3015','201','2003-06-13', 'coach
children\'s league ')
I want the output looks like:
INSERT INTO week VALUES (“2004-03-23
10:13:00“,“3015“,“201“,“2003-06-13“, “coach children's
league”)
So, is there any way to define mysqldump output file
format?
Thanks,
Monet
__________________________________
Do you Yahoo!?
Yahoo! Mail is new and improved - Check it out!
http://promotions.yahoo.com/new_mail
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
