/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

2 votes188 views3 answers
Mysql pass command from command line
SQL
15 votes216 views5 answers
Select all tables sql
SQL
0 vote204 views1 answer
Oracle execute immediate quotes
SQL
0 vote233 views1 answer
Gcloud sql instance list
SQL
0 vote187 views1 answer
Inserted row count tsql
SQL
0 vote193 views1 answer
Python connect microsoft sql server
SQL
0 vote204 views1 answer
Best practive to pass multiple table to stored procedure in sql server
SQL
7 votes193 views4 answers
How to reset the identity column in sql server
SQL
3 votes204 views1 answer
Oracle apex message quit website
SQL
0 vote251 views1 answer
Create table as select sql server error
SQL