/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 vote188 views1 answer
How to find database collation in postgres
SQL
1 vote210 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL
2 votes184 views2 answers
Get all tables using like
SQL
3 votes163 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL
1 vote188 views2 answers
Mysql remove first and last character from string
SQL
0 vote242 views1 answer
Osm2pgsql mac
SQL
0 vote186 views1 answer
Mysql cast null to string
SQL
1 vote197 views1 answer
Trigger in postgresql to change incoming entry
SQL
2 votes192 views1 answer
Sql OR
SQL
1 vote195 views1 answer
Table valued functions in sql
SQL