SQL code: UPDATE `footballmatch`.`promote` SET `pr_ballhype` = http://ballhype.com/post/url/?url=http%3A//www.allfootballtv.com/%3Fp%3D369&league=8 WHERE `promote`.`fm_post_id` =369
以上sql语句存入mysql中的时候提示错误： 1064: 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 '://ballhype.com/post/url/?url=http%3A//www.allfootballtv.com/%3Fp%3D369&league=8' at line 2
pr_ballhype 字段类型为varchar
请问该如何修改呢？
varchar型看看字符是否足够用。 UPDATE `footballmatch`.`promote` SET `pr_ballhype` = 'http://ballhype.com/post/url/?url=http%3A//www.allfootballtv.com/%3Fp%3D369&league=8' WHERE `promote`.`fm_post_id` =369 //分号少不了！ htmlspecialchars(),
