INSERT INTO test2(id,val1,val2,val5,val3,val4) SELECT *, '3', '4' FROM test1;