/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 votes332 views2 answers
Sql percentage
SQL
0 vote351 views1 answer
Min:sec datediff mssql
SQL
0 vote320 views1 answer
Query to count the number of rows in a table in sqlalchemy
SQL
-1 vote322 views1 answer
Su: Authentication failure mysql
SQL
0 vote339 views1 answer
Set default value now() date
SQL
0 vote450 views1 answer
Sql developer export connections
SQL
0 vote347 views1 answer
Exception message: The connection name 'SqlServices' was not found in the applications configuration or the connection string is empty.
SQL
1 vote349 views1 answer
Where not in array sql
SQL
0 vote322 views1 answer
Oserror mysql_config not found virtualenv
SQL
0 vote339 views1 answer
T sql dynamic top n query
SQL