/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 vote250 views1 answer
Sql convert datetime to year
SQL
0 vote208 views1 answer
Expose db in virtualbox
SQL
8 votes274 views3 answers
SQL column name
SQL
1 vote241 views1 answer
Mysql count words
SQL
0 vote251 views2 answers
Sql 2 way of select unique
SQL
0 vote260 views1 answer
Sql replace id with name from another table
SQL
0 vote264 views1 answer
Mariadb datetime change to microseconds
SQL
0 vote251 views1 answer
How to print records of employees hired in particular month in oracle
SQL
1 vote253 views1 answer
Sql to mongodb query converter
SQL
0 vote274 views1 answer
Wordpress database query change url
SQL