A
A
Alexander2016-09-28 13:57:11
MySQL
Alexander, 2016-09-28 13:57:11

How to remove special characters when importing sql file?

mysql -u root -pmypass -h localhost dbname < 1111.sql
ERROR at line 66613: Unknown command '\"'.
yes, there really is a "\" in this line, how can I remove it?
tell me what you can think of

Answer the question

In order to leave comments, you need to log in

2 answer(s)
D
Dmitry Bannik, 2016-09-28
@unix0

query.sql file
query.sql file result

INSERT INTO `Street` (`ID`, `Name`, `Id_Gorod`) VALUES (507,"\\",167);

V
Viktor Taran, 2016-09-28
@shambler81

Can you give me the line?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question