MySQLDUMP issue with backslash or special characters
Code: use test;
CREATE TABLE Test_user(Username VARCHAR(15),path VARCHAR(100));
INSERT INTO Test_user VALUES('new1','C:\newfolder\one.xlsx'); INSERT INTO Test_user VALUES('new1','C:/newfolder/one.xlsx');
I have created a .sql file using MySQLDump, which has contents
Filename : Table1.sql
DROP TABLE IF EXISTS test_user; /*!40101 SET @saved_cs_client = @@character_set_client /; /!40101 SET character_set_client = utf8 /; CREATE TABLE test_user ( Username varchar(15) DEFAULT NULL, path varchar(100) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /!40101 SET character_set_client = @saved_cs_client */;
LOCK TABLES test_user WRITE; /*!40000 ALTER TABLE test_user DISABLE KEYS /; INSERT INTO test_user VALUES ('new1','C:\newfolderone.xlsx'),('new1','C:/newfolder/one.xlsx'); /!40000 ALTER TABLE test_user ENABLE KEYS */; UNLOCK TABLES;
in the above Table1.sql file ('new1','C:\newfolderone.xlsx') backslash before one.xlsx is not displaying , While trying to execute this file, i am getting output like this
new1 C:ewfolderone.xlsx new2 C:/newfolder/one.xlsx
Where it is not displaying \ at all , suggest me how to resolve it and also what are special characters like this backslash will create this kind of bug.
Thanks in advance..
Subject
Views
Written By
Posted
MySQLDUMP issue with backslash or special characters
3185
March 21, 2017 07:10AM
905
March 21, 2017 10:21AM
748
March 21, 2017 10:41AM
779
April 20, 2017 11:59AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.