mysql - 如何在一个 MySQL 查询中组合两个 UPDATE 语句？

Question

问候，

如何在一个查询中执行两个 UPDATE 语句，例如:

UPDATE albums SET isFeatured = '0' WHERE isFeatured = '1'

结合

UPDATE albums SET isFeatured = '1' WHERE id = '$id'

基本上，当推荐新专辑时，之前推荐的专辑会切换回正常状态，而新推荐的专辑会被设置为活跃。

谢谢!

Answer 1

试试这个:

UPDATE albums SET isFeatured = IF(id!='$id', '0','1')