Replace command & backslash
I'm using MySql 5.6 on CentOS 6.5 and i need to change backslash chars in some columns of my table. I've found some errors so i've decided to test replace command with simple string:
SELECT REPLACE('ashnet.it\maurizio\', '\', '/'); -> error 1064
SET sql_mode = NO_BACKSLASH_ESCAPES;
SELECT REPLACE('ashnet.it\maurizio\', '\', '/'); -> no error but no replace done
SELECT REPLACE('ashnet.it\maurizio\*', '\', '/'); -> replace done !
someone know why adding * the replace is done ?
Subject
Views
Written By
Posted
Replace command & backslash
3995
November 16, 2014 03:03AM
1400
November 17, 2014 12:10AM
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.