/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 vote171 views1 answer
Check connections to database postgres
SQL
0 vote183 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL
0 vote198 views1 answer
Oracle concat datetime
SQL
3 votes185 views3 answers
Raw select laravel
SQL
0 vote180 views1 answer
T sql cursor tr
SQL
0 vote185 views1 answer
Sql common columns
SQL
0 vote176 views1 answer
Add multiple field in table sql
SQL
0 vote183 views1 answer
Sql server select record with max id
SQL
0 vote184 views1 answer
How to write if case in select query in select statement
SQL
0 vote174 views1 answer
How to find username and password in oracle 18c
SQL