Home > Article > Backend Development > 求 数据库的update语句问题
求 数据库的update语句问题
- WBOYOriginal
- 2016-06-23 14:23:231081browse
poster的值为2 要怎么批量把poster的值为1
我的数据库语句如下
update user set poster = 1 WHERE poster = 2
但是却报错
Unknown column 'poster' in 'where clause'
要怎么批量把poster的值批量修改为2(原本值为1)
回复讨论(解决方案)
update `user ` set `poster `=1 where `poster `=2
update `user ` set `poster `='1' where `poster `='2'
Unknown column 未知列
请检查字段名是否写错了
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：socket多用户连接求助Next article：sublime text2 保存php文件提示“无法启动此程序，因为计算机中丢失php_pdo.dll 尝试重新安装该程序以解决此问题”