/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 vote182 views1 answer
Sql developer format sql
SQL
-1 vote142 views1 answer
Auto increment psql not primary key
SQL
0 vote119 views1 answer
Ms sql unique
SQL
0 vote147 views1 answer
Sql remove first character from string
SQL
6 votes95 views2 answers
Spring data jpa application.properties mysql
SQL
0 vote139 views1 answer
Set column in all row mysql
SQL
0 vote141 views1 answer
Find and replace query in wordpress\
SQL
1 vote154 views1 answer
Find difference in dates sql
SQL
7 votes131 views3 answers
How to check table name in current database sql
SQL
2 votes138 views1 answer
How to check if a row is null in sql
SQL