My sql 语法
INSERT INTO B SELECT id,username,PASSWORD,NAME,sex ,#{0},#{1} FROM A
Sql server 语法
insert into b(id,name,password,sex) select id,name,password,'纯爷们' from a;
My sql 语法
INSERT INTO B SELECT id,username,PASSWORD,NAME,sex ,#{0},#{1} FROM A
Sql server 语法
insert into b(id,name,password,sex) select id,name,password,'纯爷们' from a;