<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>