/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 vote345 views1 answer
Multiple replace value mssql
SQL
0 vote341 views3 answers
Magento 2 order delete from db
SQL
2 votes325 views1 answer
Drop table purge
SQL
2 votes356 views2 answers
Sql query to list all tables in a database sql server
SQL
0 vote347 views1 answer
Set default value now() date
SQL
0 vote423 views1 answer
Play framework connection via windows sql server
SQL
21 votes335 views4 answers
Oracle add column
SQL
2 votes296 views1 answer
Foreign key example in dbms
SQL
0 vote333 views1 answer
Drop constraint in ms sql
SQL
1 vote325 views1 answer
How to make a select in sql
SQL