MySQL 数据库 pano_pano_fenzu 表：批量更新 parent 和 group 字段并插入新记录

UPDATE pano_pano_fenzu SET parent='top', group=0;

INSERT INTO pano_pano_fenzu (parent, group) SELECT 'child', group FROM pano_pano_fenzu WHERE parent='top' AND id=[查询id的记录的id];