/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 vote342 views1 answer
Oracle undo usage per session
SQL
0 vote311 views1 answer
Microsoft word insert sql code
SQL
4 votes329 views2 answers
Bulk kill mysql processlist
SQL
1 vote344 views2 answers
Group_concat limit mysql
SQL
0 vote324 views1 answer
Mysql pv progres
SQL
1 vote325 views1 answer
Oracle index partition
SQL
7 votes306 views4 answers
How to reset the identity column in sql server
SQL
0 vote315 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL
0 vote356 views1 answer
Mysql db dump restore max file size issue
SQL
0 vote339 views1 answer
Print mysql
SQL