/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

49 votes426 views6 answers
Mysql add column to table
SQL
4 votes361 views3 answers
Rename table column postgresql
SQL
0 vote345 views1 answer
Python mysqlclient library not found for -lssl
SQL
0 vote354 views1 answer
C# add a textbox in mysql select
SQL
21 votes386 views6 answers
Update sql
SQL
0 vote372 views1 answer
Doctors appointment
SQL
0 vote353 views1 answer
Vowels in sql
SQL
0 vote345 views1 answer
NLS_NCHAR_CHARACTERSET
SQL
0 vote323 views1 answer
Sql roll up rows into columns
SQL
0 vote324 views1 answer
Mysql max number not returning correct value
SQL