Home > Article > Backend Development > 求 数据库的update语句有关问题
求 数据库的update语句有关问题
- WBOYOriginal
- 2016-06-13 12:36:34810browse
求 数据库的update语句问题
poster的值为2 要怎么批量把poster的值为1
我的数据库语句如下
<br /> update user set poster = 1 WHERE poster = 2<br />
但是却报错
Unknown column 'poster' in 'where clause'
要怎么批量把poster的值批量修改为2(原本值为1)
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： 想知道这个是什么框架的索引结构 Next article： 求高手 拯救小弟我PHP变量后面带[]是什么 意思