/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

11 votes106 views2 answers
Docker create postgres db
SQL
9 votes142 views1 answer
No sql
SQL
1 vote99 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote107 views1 answer
How to delete python anywhere mysql database
SQL
0 vote111 views2 answers
Greater than sql server
SQL
0 vote103 views1 answer
Oracle job class
SQL
0 vote104 views2 answers
Sql having multiple conditions
SQL
0 vote101 views1 answer
Mysql query to check record exists in database table or not
SQL
3 votes109 views1 answer
Sql is not like
SQL
0 vote105 views1 answer
Mysql select distinct date from timestamp
SQL