/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

22 votes229 views1 answer
Mysql workbench
SQL
7 votes174 views4 answers
Database dump mysql command
SQL
0 vote183 views2 answers
Search stored procedures by name
SQL
-1 vote186 views1 answer
Add 10 to all numbers in a column sql
SQL
0 vote171 views2 answers
Mysql unique two columns
SQL
2 votes176 views1 answer
Copy all values of a column to another column in sql in same table
SQL
1 vote169 views1 answer
How to install mysql 8.0 windows service
SQL
0 vote176 views1 answer
Oracle SQL join three tables and group by column
SQL
1 vote208 views1 answer
Postgresql Insufficient privilege: 7 ERROR: permission denied for table
SQL
1 vote173 views1 answer
Oracle extract minute from date
SQL