/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 vote297 views1 answer
Mysql default timestamp value to be current timestamp
SQL
13 votes273 views5 answers
Oracle list tables
SQL
0 vote290 views1 answer
Complete date is 1 year or not sql server
SQL
0 vote291 views1 answer
Mysql date minus 1 day
SQL
1 vote315 views1 answer
Key validation sql
SQL
4 votes292 views3 answers
Oracle sql first day of quarter
SQL
0 vote322 views1 answer
Sql remove non numeric characters
SQL
0 vote317 views1 answer
Replace divide by zero error with 0 in sql
SQL
0 vote291 views1 answer
Export partttion and import in oracle
SQL
16 votes304 views4 answers
Ascending order mysql
SQL