示例:
insert into mytable(X,Y,Z)
Values((SELECT X from basetable WHERE ID = 8),(SELECT Y from basetable WHERE ID = 8),(SELECT Z from basetable WHERE ID = 8));
示例:
insert into mytable(X,Y,Z)
Values((SELECT X from basetable WHERE ID = 8),(SELECT Y from basetable WHERE ID = 8),(SELECT Z from basetable WHERE ID = 8));