altering/inserting data in INSERT ... SELECT statements

[xdentan]

If I had the query:

INSERT INTO table2 (x, y) SELECT table1.x, table1.y FROM table1

Is it possible to add 1 to the x values and subtract 1 from the y values before copying the values over to table2 (that is without actually altering table1 beforehand)? Also, is it possible to insert predetermined data into other columns in the same statement (as with normal INSERT queries)?

I'd also like to combine the data from table1 into a single string using CONCAT in the INSERT statement. Is this possible?

I realize this could probably be accomplished by creating a temporary column in table2 to indicate which rows need to be manipulated, but I'm trying to avoid temporary columns and tables for simplicity.

thanks

[NogDog]

Yes, I believe both are possible (though I've not tried it), something like:

INSERT INTO `table1` (`x`, `y`, `z`) SELECT `x` + 1, `y`, 'literal value' FROM table1

[xdentan]

Thanks!