Inserting using select, plus extra data

[fry2010]

I wondered if it is possible to perform a statement that does a select insert with extra parameters included. Eg:

 

Combine these two queries:

 

INSERT INTO `table1` SELECT `val1`, `val2` FROM `table2`;

INSERT INTO `table1` VALUES (`val3`, `val4`);

[fenway]

I'm sorry -- do you want one row or two?

[requinix]

If you mean

INSERT INTO `table1` SELECT `val1`, `val2` FROM `table2`;
INSERT INTO `table1` SELECT `val3`, `val4` FROM `table2`;

then yes, you can combine them using a UNION.

[DavidAM]

If you are talking about adding literal values, then yes, you can do that too. You can add literals to any select:

 

INSERT INTO tableName (col1, col2, col3, col4)
SELECT someCol1, someCol2, 'Literal Value', 123 
FROM tableName2

 

For every row in tableName2, insert a row into tableName; assigning someCol1 to col1, and someCol2 to col2; and also assign "Literal Value" to col3 and 123 to col4 in every row inserted