/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

1 vote223 views3 answers
Reseed sql table primary key
SQL
0 vote181 views1 answer
Knex last insert id mysql
SQL
0 vote206 views1 answer
Exectuer myssql .sql
SQL
1 vote214 views1 answer
Apex select list ORA-20999
SQL
0 vote162 views1 answer
Mysql select top 2
SQL
1 vote207 views1 answer
How to check the mysql version mac
SQL
0 vote186 views1 answer
Declare date variable sql
SQL
0 vote188 views1 answer
Java input type sql date
SQL
0 vote183 views3 answers
Sql count condition
SQL
14 votes204 views2 answers
Install mysqldump
SQL