/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

8 votes167 views1 answer
Ltrim sql
SQL
0 vote163 views3 answers
Query string not ending with with vowels
SQL
0 vote125 views1 answer
Hangfire clean script
SQL
0 vote166 views2 answers
Timing sql queries
SQL
1 vote166 views1 answer
Mysql workbench in ubuntu 14.04
SQL
17 votes150 views4 answers
Sort by mysql
SQL
0 vote147 views4 answers
Mysql on kubernetes
SQL
1 vote236 views1 answer
Create new table from old table with data
SQL
29 votes160 views6 answers
Delete all rows from table mysql
SQL
0 vote156 views1 answer
Write a query to peint the pattern P(20)
SQL