CODEWITHSUNDEEP
mysqlbashescapingbackslash
Ed Manet
Ed Manet

Reputation: 3178

using backslashes with bash and mysql

This is boggling my mind today. I have a bash script to set a value in a MySQL table: The value I have to set is to UNC path with a trailing backslash: \\$HOSTNAME\path\

Inside mysql the query works:

update mytable SET myvalue = '\\\\MYSERVER\\path\\' WHERE ID=10;

But from bash, it fails:

mysql -e "update mytable SET myvalue = '\\\\$HOSTNAME\\path\\' WHERE ID=10;"

MySQL gives a syntax error:

ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; 
check the manual that corresponds to your MySQL server version for the 
right syntax to use near ''\\MYSERVER\path\' WHERE ID=10' at line 1

Any help is greatly appreciated.

Upvotes: 3

Views: 1586

Answers (2)

Pavel Vlasov
Pavel Vlasov

Reputation: 3465

mysql -e 'SELECT "\\\\server\\path\\"'
mysql -e 'update mytable SET myvalue = "\\\\server\\path\\" WHERE ID=10;'

Upvotes: 0

Dennis Williamson
Dennis Williamson

Reputation: 359965

Because it's inside double quotes, you'll need to double all those backslashes.

If you don't need to expand any shell variables, swap the single and double quotes instead.

Upvotes: 3

Related Questions