/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
Wordpress change url phpmyadmin
SQL
0 vote324 views1 answer
Timestamp(0) postgresql
SQL
0 vote301 views1 answer
Check if table exists oracle
SQL
0 vote340 views1 answer
Create user faunadb
SQL
0 vote303 views1 answer
Restart sql server command line linux
SQL
0 vote318 views1 answer
PDOException: SQLSTATE[HY093]: Invalid parameter numb
SQL
1 vote316 views1 answer
Oracle drop job if exists
SQL
2 votes300 views2 answers
Mysql date range
SQL
12 votes305 views1 answer
Docker mysql random root password
SQL
1 vote302 views2 answers
Sql select only row with the max date
SQL