/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 vote344 views1 answer
Optimize sql query
SQL
11 votes393 views1 answer
Oracle export view ddl
SQL
0 vote338 views1 answer
SQL Server modify_timestamp trigger
SQL
2 votes380 views3 answers
Sql function
SQL
0 vote380 views1 answer
Mysql reset wp_options
SQL
2 votes356 views4 answers
Mysql select into new table
SQL
1 vote308 views1 answer
Mssql string length
SQL
0 vote352 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
0 vote373 views1 answer
Oracle table privileges
SQL
21 votes357 views4 answers
Oracle add column
SQL