/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

1 vote307 views1 answer
Sqlalchemy on delete set null
SQL
0 vote256 views1 answer
Postgresql parse json array
SQL
0 vote275 views1 answer
Mariadb number format
SQL
11 votes297 views3 answers
Sql_mode=only_full_group_by
SQL
0 vote298 views1 answer
Mysql trigger to delete old data
SQL
0 vote283 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL
4 votes269 views1 answer
Oracle delete last row
SQL
-1 vote251 views2 answers
Sql server date format yyyy-MM-ddThh:mm:ss
SQL
0 vote265 views1 answer
Forcefully delete a row in mysql which has references
SQL
0 vote275 views1 answer
Select last N rows mysql
SQL