/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 vote117 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
0 vote155 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
0 vote142 views1 answer
Sql query to return field name of a table
SQL
0 vote135 views2 answers
How to find max and min salary in sql
SQL
0 vote136 views1 answer
Alter table change default
SQL
0 vote139 views1 answer
Redshift running queries
SQL
0 vote126 views1 answer
Alter table myisam to innodb
SQL
0 vote119 views1 answer
Resulting Query
SQL
1 vote127 views2 answers
Pad zero sql server
SQL
6 votes170 views3 answers
[2021-10-05T13:43:48.961Z] error Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL