/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

1 vote197 views1 answer
Select last row from SQL Table
SQL
0 vote159 views1 answer
How to display value of variable in mysql
SQL
1 vote344 views1 answer
Foreign key in oracle sql developer
SQL
7 votes157 views2 answers
3rd height salary sql
SQL
0 vote174 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
3 votes156 views1 answer
Locate sql server
SQL
9 votes143 views1 answer
Sql server get utc date
SQL
6 votes185 views2 answers
WHERE value IS sql
SQL
6 votes143 views4 answers
Delete table sqlite
SQL
10 votes163 views4 answers
Else if mysql
SQL