我想你必须写一个子查询。 例如。
UPDATE products_description SET products_description = (SELECT your_column FROM products_to_categories WHERE id_categories = products_description.products_id LIMIT 1)
UPDATE products_description SET products_description = 'YOUR TEXT' WHERE product_id IN ( SELECT products_id FROM products_to_categories WHRE id_categories = 309 )
顺便说一下,为你的表和列尝试更好的名字。如果您的表名为products_descriptions,则无需为其中一个列命名 products_description 你可以命名它 description 。
products_description
description