/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 vote354 views1 answer
Update database collation in postgresql
SQL
2 votes346 views1 answer
Oracle table size
SQL
0 vote365 views1 answer
Update sqlite
SQL
0 vote342 views1 answer
Psql no such file or directory
SQL
9 votes369 views6 answers
Sql add column with default value
SQL
1 vote363 views1 answer
Trigger in postgresql to change incoming entry
SQL
19 votes361 views5 answers
Mysql between date range
SQL
0 vote344 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL
0 vote360 views1 answer
Mysql add root password
SQL
5 votes381 views1 answer
How to get all table names in sql query
SQL