/SQL/Mysql insert multiple rows based on select

Mysql insert multiple rows based on select

INSERT INTO table1 (col1, col2, col3, col4, col5) 
SELECT col1,col2,col3,col4,col5 
FROM table2 t2 
WHERE t2.val2 IN (MULTIPLE VALUES) 
AND (Another Conditional);

Source: stackoverflow.com

Similar codes

0 vote227 views1 answer
Sql insert tuple
SQL
6 votes231 views4 answers
Remove spaces sql server
SQL
2 votes251 views1 answer
Postgresql create schema in specific database
SQL
0 vote324 views1 answer
Compare strings lexicographically in sql
SQL
11 votes233 views2 answers
Set default column value sql
SQL
1 vote232 views1 answer
Mysql limit results to 10
SQL
0 vote247 views2 answers
CREATE OR REPLACE FUNCTION
SQL
1 vote231 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception table not found
SQL
0 vote258 views2 answers
Add colum in sql
SQL
0 vote223 views1 answer
Sql row number in result set
SQL