表table_a,表table_b,现在要将b表中的几个字段值插入表a,且两张表字段名字不同
insert into table_a(user, pwd, score) select username user, password pwd, score from table_b.
表table_a,表table_b,现在要将b表中的几个字段值插入表a,且两张表字段名字不同
insert into table_a(user, pwd, score) select username user, password pwd, score from table_b.