34,590
社区成员
发帖
与我相关
我的任务
分享
INSERT INTO A(id,className,classteacher) SELECT id,className,classTeacher FROM B
INSERT INTO A(name,className,classteacher) SELECT '默认姓名',(SELECT className,classTeacher FROM B)
INSERT INTO A(name,className,classteacher) SELECT '默认姓名'className,classTeacher FROM B
insert into
a(id,name,className,classteacher)
select
id,'默认姓名',className,classTeacher
FROM
B