/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

16 votes189 views1 answer
CTE statement sql server
SQL
1 vote222 views1 answer
Postgresql can you have null foreign key
SQL
2 votes213 views3 answers
How to get second highest salary in each department in sql
SQL
0 vote191 views1 answer
Oracle simple quote
SQL
0 vote185 views1 answer
Mysql url
SQL
2 votes193 views2 answers
Sql lag
SQL
3 votes197 views1 answer
Select sequence oracle
SQL
1 vote179 views1 answer
How to start with sql
SQL
0 vote228 views1 answer
Mysql order by where condition sub query
SQL
0 vote208 views1 answer
Delete a record from a table sqlite3
SQL