/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

4 votes112 views2 answers
Select todays data postgres query
SQL
1 vote155 views1 answer
How to transfer pandas datafra,e to sqlite
SQL
0 vote136 views1 answer
Alter table add foreign key mariadb example
SQL
2 votes144 views1 answer
Oracle find unusable indexes
SQL
0 vote139 views2 answers
Sqlite
SQL
0 vote152 views1 answer
Oracle select partition
SQL
1 vote249 views3 answers
Uninstall postgresql mac
SQL
0 vote158 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
11 votes149 views2 answers
Oracle source code
SQL
0 vote147 views1 answer
Cartesian product sql
SQL