/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 vote137 views1 answer
Limit and offset in stored procedure mssql
SQL
0 vote132 views2 answers
SQL Server Standard
SQL
24 votes139 views5 answers
List mysql users
SQL
2 votes153 views3 answers
How do I add a user to a postgres database? cli
SQL
3 votes167 views1 answer
RENAME table pl sql
SQL
0 vote172 views1 answer
Stop and start mysql
SQL
1 vote142 views1 answer
Convert varchar to int in sqlite
SQL
0 vote153 views1 answer
Postgresql inheritance
SQL
1 vote153 views1 answer
Mysql not supported auth mode
SQL
8 votes158 views3 answers
Find table for column name in sql
SQL