/SQL/Insert multiple rows from another table sql

Insert multiple rows from another table sql

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;

Insert multiple rows from another table sql

INSERT INTO NewTable SELECT * FROM ExistingTable;

Similar codes

0 vote198 views1 answer
Sql update subtract value
SQL
1 vote190 views1 answer
Random name function in mysql for nvarchar
SQL
0 vote182 views1 answer
Tsql generate rows
SQL
2 votes180 views1 answer
Get hour from date sql
SQL
0 vote172 views1 answer
Backup and restore of sqlite database from c# -sqlserver
SQL
10 votes174 views5 answers
Between keyword in sql
SQL
2 votes185 views3 answers
How to check current user in mySQL
SQL
0 vote210 views1 answer
Traccar mysql
SQL
0 vote195 views1 answer
Mysql dump with table query
SQL
0 vote187 views1 answer
Sql server roles and users
SQL