/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 vote201 views1 answer
Number(10 2) in sql means
SQL
0 vote219 views1 answer
Distance calculator from lat long sql query
SQL
3 votes208 views3 answers
Raw select laravel
SQL
5 votes195 views1 answer
Postgresql functions
SQL
1 vote212 views1 answer
Oracle nvl2
SQL
-1 vote205 views1 answer
How to switch user in mysql
SQL
1 vote233 views3 answers
How to update column name in psql
SQL
2 votes206 views3 answers
Postgresql reset auto increment
SQL
0 vote215 views1 answer
Get substract count sql
SQL
3 votes205 views1 answer
Oracle user privileges
SQL