/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 vote86 views1 answer
How to get last client id sql
SQL
0 vote124 views2 answers
Insert into
SQL
0 vote102 views1 answer
Postgresql add leading zeros
SQL
2 votes124 views4 answers
ModuleNotFoundError: No module named 'mysql'
SQL
0 vote129 views1 answer
Oracle query archive mode
SQL
0 vote131 views1 answer
How to see password mysql vestacp
SQL
0 vote136 views1 answer
Comma seperated join mssql
SQL
8 votes168 views1 answer
Racle create auto increment column
SQL
0 vote122 views1 answer
Sqlite to csv statement
SQL
9 votes136 views1 answer
Oracle get table schema
SQL