/SQL/Sql insert multiple rows from select

Sql insert multiple rows from select

INSERT INTO my_table SELECT * FROM source_table;
INSERT INTO my_table (a, b, c) SELECT a, b, c FROM source_table;
INSERT INTO my_table (a, b, c) SELECT a, b, c FROM source_table s
	WHERE s.my_col >= 10;

Similar codes

2 votes144 views1 answer
Mysql query unique column
SQL
0 vote145 views1 answer
Mysql find db contarint
SQL
0 vote144 views1 answer
Sql composite key
SQL
0 vote151 views1 answer
Mysql count unique in group statement
SQL
2 votes158 views1 answer
Pdo mysql insert
SQL
1 vote169 views1 answer
Sqlite update from another table
SQL
6 votes138 views1 answer
Rank function in oracle with example
SQL
0 vote148 views1 answer
Services.AddDbContext DataSource Sqlite
SQL
0 vote160 views1 answer
C# execute transact sql
SQL
0 vote146 views1 answer
Pl/sql loop example
SQL