/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 vote353 views1 answer
SQL query to get all table records count from a database
SQL
0 vote331 views1 answer
Sql server current time without date
SQL
0 vote343 views1 answer
Sql get count without group by
SQL
2 votes305 views1 answer
Oracle sql drop column if exists
SQL
4 votes335 views2 answers
Oracle sql group by date year
SQL
1 vote345 views4 answers
Sql now
SQL
0 vote330 views1 answer
Find all tables where column name exists oracle
SQL
0 vote327 views1 answer
Postgresql create user roles
SQL
0 vote336 views1 answer
Postgresql default value boolean
SQL
0 vote315 views1 answer
Check mysql password with docker container magento 2
SQL