<p class="sougouContent"> poster的值为2 要怎么批量把poster的值为1 <br> 我的数据库语句如下 <div class="code" style="position:relative; padding:0px; margin:0px;"><pre class="sycode" name="code">update user set poster = 1 WHERE poster = 2</pre><div class="contentsignin">로그인 후 복사</div></div> <br> 但是却报错 <br> Unknown column 'poster' in 'where clause' <br> <br> 要怎么批量把poster的值批量修改为2(原本值为1) </p> <br> <h2>回复讨论(解决方案)</h2> <p class="sougouAnswer"> update `user ` set `poster `=1 where `poster `=2 </p> <p class="sougouAnswer"> update `user ` set `poster `='1' where `poster `='2' </p> <p class="sougouAnswer"> Unknown column 未知列 <br> 请检查字段名是否写错了 </p>
![[웹 프런트엔드] Node.js 빠른 시작](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
