douxin8610
2017-05-07 18:37使用php更新mysql表时如何添加许多WHERE约束?
How can I add multiple constraints after the WHERE part of the UPDATE MySQL table statement? Is this possible? I have tried separating the constraints using commas. Thank you.
$update_error = mysqli_query($con, "UPDATE users SET error_level='3'
WHERE errors <= '650', errors > '200'");
- 点赞
- 回答
- 收藏
- 复制链接分享
3条回答
为你推荐
- 查询返回null
- mysql
- pdo
- php
- 2个回答
- CodeIgniter - 如何捕获数据库错误?
- codeigniter
- php
- 11个回答
- CakePHP saveAll()具有唯一约束
- mysql
- php
- 2个回答
- 雄辩的多个嵌套关系与约束
- laravel
- mysql
- php
- 2个回答
- 表创建中php代码中的外键约束
- mysql
- php
- 1个回答
换一换