示例:两张表,一张是admin(id,username,pass),info(id,Integral);
条件 : info 的Integral的值要插入到username里,pass也要插入自定义的值
insert into admin(username,pass) select Integral,'123' from info where id=1 //查出值后添加到username字段中
insert into admin(username,pass) select sum(Integral),'123' from info where id in (1,2) //根据条件查出两个值的总和,然后插入到admin表中