/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 vote119 views3 answers
Drop unique key constraint in sql server
SQL
0 vote144 views1 answer
Sql anywhere create procedure
SQL
0 vote114 views1 answer
Power bi dax add related shows column but not working
SQL
0 vote140 views2 answers
How to retrive image from sql to picturebox usinf image location
SQL
2 votes131 views1 answer
Removing view
SQL
1 vote99 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL
0 vote134 views1 answer
Running percentage of total postgres
SQL
5 votes135 views4 answers
Start postgres server
SQL
0 vote71 views1 answer
Get last run query sql server
SQL
0 vote119 views1 answer
Limit and offset in stored procedure mssql
SQL