MySQL where 子句
在所有示例中,他们都在子句中讨论静态字符串:
update ranking_data set ft_kw = NULL
WHERE ranking_data.website = 'abc.com';
好的,但是如果我们想要动态字符串怎么办?
update ranking_data set ft_kw = NULL WHERE ranking_data.website = $website_name;
这是行不通的。单引号消除了错误消息,但无法正确执行。 ft_kw 永远不会被设置,即使是完美匹配。
谁能给我变量字符串的正确语法?
In all the samples they talk about a static string in the clause:
update ranking_data set ft_kw = NULL
WHERE ranking_data.website = 'abc.com';
Okay but what if we want a dynamic string?
update ranking_data set ft_kw = NULL WHERE ranking_data.website = $website_name;
Which does not work. Single quote gets rid of the error msg but does not execute properly. ft_kw is never set, even a perfect match.
Can anyone give me the proper syntax on a variable string?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
尝试在 $website_name 周围添加单引号:
Try adding singlw quotes around $website_name: