/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
How to get distinct sets of rows using SQL (Oracle)?
SQL
3 votes236 views5 answers
Duplicate table sql
SQL
4 votes232 views1 answer
Mysql ip address data type
SQL
0 vote223 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
7 votes208 views1 answer
Query delete duplicates
SQL
0 vote227 views1 answer
Flask sqlalchemy remove duplicates
SQL
0 vote209 views1 answer
Sql revert migration
SQL
12 votes226 views2 answers
Delete all entries postgres
SQL
0 vote214 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
0 vote239 views1 answer
Mysql update all record removing 2 hours from column
SQL