/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 vote208 views1 answer
Sql count null values in all columns
SQL
0 vote204 views1 answer
Mariadb search columns
SQL
0 vote199 views1 answer
After kill process Failed to start mysqld.service: Unit mysqld.service not found.
SQL
1 vote196 views1 answer
Add sequence postgres
SQL
4 votes189 views1 answer
Sql any
SQL
0 vote200 views1 answer
Mysql listing get a particu particular user firsdt
SQL
0 vote226 views1 answer
Dynamic where clause in sql server stored procedure
SQL
0 vote202 views2 answers
Oracle select
SQL
0 vote186 views1 answer
Dump only schema
SQL
21 votes195 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL