hand = 0类别status应该更新为"deactivated"这些是我的表 +-------+----------+-------------------+
| CatId | status | catagoryUPDATE catagory INNER JOIN item ON catagory.CatId = item.CatId SET catagory.
SELECT * CatagoryLEFT JOIN products.PriceWHERE ((Catagory.Category='Ring' OR Catagory.Category='Earings') AND(products.Price<=30))
ORDER BY products.PriceSELECT * Catagory