单引号未做处理:
SELECT * FROM search_engine.t_patents_relations_wse where patent_name = ‘一种3,7-二甲基-9-(2’,6’,6’-三甲基-1-环己烯)基-2,4,7-三烯-1,6-二醇的制备方法’;
结果 SQL 错误 [42601]错误
SQL 错误 [42601]: Unterminated string literal started at position 128 in SQL SELECT * FROM search_engine.t_patents_relations_wse where patent_name = ‘一种3,7-二甲基-9-(2’,6’,6’-三甲基-1-环己烯)基-2,4,7-三烯-1,6-二醇的制备方法’
. Expected char
解决方式: 两个单引号进行转义
SELECT * FROM search_engine.t_patents_relations_wse where patent_name = ‘一种3,7-二甲基-9-(2’’,6’’,6’’-三甲基-1-环己烯)基-2,4,7-三烯-1,6-二醇的制备方法’;