mysql - #1064 语法错误 : In "Update Query"

Question

当我使用这段mysql代码时

update catalog_product_entity_decimal
  set value = "6.0000" 
  where attribute_id = 75 and
        entity_in ( SELECT 
        product_id 
        from `catalog_category_product` 
        WHERE category_id =37 );

我遇到了这个错误

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT product_id from `catalog_category_product` ' at line 4

我无法弄清楚我的查询有什么问题。谁能告诉我哪里出了问题？

谢谢

Answer 1

您在 entity_in 之后缺少 IN 子句。使用这个:

update catalog_product_entity_decimal
  set value = "6.0000" 
  where attribute_id = 75 and
        entity_id IN ( SELECT 
        product_id 
        from `catalog_category_product` 
        WHERE category_id =37 );