/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 vote169 views1 answer
Oracle current session details
SQL
11 votes221 views3 answers
Pl sql example
SQL
0 vote214 views2 answers
SQL BULK INSERT
SQL
0 vote166 views1 answer
Search db for table name
SQL
2 votes163 views2 answers
How to view created temporary tables in mysql
SQL
5 votes172 views2 answers
Postgres update with if condition query
SQL
0 vote177 views1 answer
C# execute transact sql
SQL
0 vote163 views1 answer
Update and keep original value sql
SQL
0 vote181 views1 answer
Extract sql from query object sqlalchemy
SQL
0 vote156 views1 answer
Learn sqlite dart
SQL