错误码:-6107
错误内容:无效的转义字符
错误级别: ERROR
原因:转义字符不能使用_
DROP TABLE T1;
CREATE TABLE T1(ID INT, NAME VARCHAR(30));
INSERT INTO T1 VALUES(1,'1114_2_看图王.JPG');
INSERT INTO T1 VALUES(1,'11142看图王.JPG');
TRUNCATE TABLE T1;
SELECT * FROM T1 WHERE NAME LIKE '%1114_2_看图王%' ESCAPE '_'
[执行语句1]:
SELECT * FROM T1 WHERE NAME LIKE '%1114_2_看图王%' ESCAPE '_'
执行失败(语句1)
-6107: 无效的转义字符
文章
阅读量
获赞