UPDATE your_table AS child
JOIN your_table AS parent ON child.parent_name = parent.name
SET child.parent_id = parent.id;
mysql 根据父级名称字段查询父级id并赋值在父级id字段
最新推荐文章于 2024-10-02 12:42:27 发布
UPDATE your_table AS child
JOIN your_table AS parent ON child.parent_name = parent.name
SET child.parent_id = parent.id;