你为什么不尝试皮特的解决方案？它只需要一些修改。

why didn't you try pete's solution? it works just needed some modification.

INSERT INTO DOMESTIC(fid, mid, fname)( SELECT fid,2,child1 FROM DOMESTIC UNION ALL SELECT fid,3,child2 FROM DOMESTIC)

这应该有效：

INSERT INTO DOMESTIC(fid, mid, fname) SELECT (fid,2,child1) FROM DOMESTIC
INSERT INTO DOMESTIC(fid, mid, fname) SELECT (fid,3,child2) FROM DOMESTIC