/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

7 votes122 views2 answers
Add column table pl sql
SQL
1 vote128 views1 answer
Mysql select for update ejemplo
SQL
0 vote149 views1 answer
For select oracle
SQL
1 vote114 views1 answer
Postgresql datetrunc too slow
SQL
0 vote120 views1 answer
Sqlalchemy query sql compiled
SQL
-1 vote162 views1 answer
Difference berween database and data base management system
SQL
3 votes120 views3 answers
Restart mysql mac
SQL
1 vote119 views1 answer
Oracle check table space
SQL
2 votes110 views1 answer
Scaffold npgsql net core
SQL
0 vote120 views1 answer
How to declare variable date in mysql
SQL