我正试图通过MySQL对一些帖子进行分类更改。
但我无法在数据库中提供更新，这是在运行查询时出错。
UPDATE *
FROM mooca_posts
LEFT JOIN mooca_term_relationships ON (mooca_posts.ID = mooca_term_relationships.object_id)
LEFT JOIN mooca_term_taxonomy ON (mooca_term_relationships.term_taxonomy_id = mooca_term_taxonomy.term_taxonomy_id)
SET mooca_term_taxonomy.term_id = \'112\'
WHERE mooca_term_taxonomy.term_id IN (1448)
GROUP BY mooca_posts.ID
我需要从1448类改为112类。
