Incorrectsyntaxnear's'
程序员文章站
2024-01-29 22:50:52
...
出错的SQL: update address set is_mapping='A',lat=39.8123779296875,lon=-74.9393539428711,Mapping_Platform='BingA',Mapping_Return_Result='High',County='04',Municipality='0406',source_address='196 Veteran's Ave, West Berlin, NJ 08091' where a
出错的SQL:
update address set is_mapping='A',lat=39.8123779296875,lon=-74.9393539428711,Mapping_Platform='BingA',Mapping_Return_Result='High',County='04',Municipality='0406',source_address='196 Veteran's Ave, West Berlin, NJ 08091' where address_id=2481200
错误发生在:source_address='196 Veteran's Ave, West Berlin, NJ 08091' , 这个字段里面有个单引号。
解决方案:将‘替换成’’
Code:sDisplayName.Replace(“'”, “''”)
上一篇: CSS - Float
下一篇: Go语言中的数组、切片和字符串
推荐阅读
-
Incorrectsyntaxnear's'
-
当我在运行'make'时,看起来一切正常,但
-
39元!小米Wi-Fi放大器上市时间曝光 小米路由器的最佳伴侣
-
mysql ERROR 2002 (HY000): Can't connect to local_MySQL
-
数据库Log之Couldn't read row 0, col
-
mysql数据库错误ERROR 1130:Host '' is not allowed
-
php截取函数,应该很简单,只是我比较菜而已,这里'utf-8
-
error: 'Access denied for user 'root'
-
解决:java.sql.SQLException: Access denied for user '&a
-
IT忍者神龟之mysql远程连接:ERROR1130(HY000):Host'*.*