/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 vote285 views1 answer
Services.AddDbContext DataSource Sqlite
SQL
1 vote321 views1 answer
How to set up a trigger in sql
SQL
0 vote274 views4 answers
How to drop all tables in sql
SQL
1 vote303 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
0 vote496 views1 answer
Get first match in each group mysql query
SQL
0 vote328 views1 answer
Mysql get first 2 characters of string
SQL
1 vote301 views3 answers
Mysql parse int
SQL
1 vote296 views1 answer
Mysql strict_trans_tables
SQL
0 vote276 views1 answer
From _sqlite3 import * ImportError: DLL load failed: Das angegebene Modul wurde nicht gefunden.
SQL
36 votes353 views6 answers
Change column data type sql
SQL