/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

-1 vote320 views1 answer
Capitole toulouse
SQL
3 votes351 views2 answers
Update part of a string in mysql
SQL
0 vote328 views1 answer
Mysql match in serialized data
SQL
0 vote338 views1 answer
Alter domain sql
SQL
0 vote306 views1 answer
Sql server remove 0 from left
SQL
0 vote328 views1 answer
Kill mysqld_safe process mariadb
SQL
25 votes344 views4 answers
Sqlserver add column
SQL
0 vote313 views1 answer
Mysql search multiple tables
SQL
1 vote338 views1 answer
Base64 encode sql server
SQL
1 vote342 views2 answers
Foreign key set 0
SQL