/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 vote241 views1 answer
CONVERT time string into 12 hours in sql
SQL
2 votes205 views2 answers
Spring import sql
SQL
31 votes186 views3 answers
Sql count(*)
SQL
1 vote176 views1 answer
Sql auto timestamp
SQL
0 vote191 views1 answer
Mysql repair a table
SQL
1 vote221 views1 answer
Sql check roles
SQL
1 vote193 views1 answer
Sql server today minus n
SQL
1 vote192 views1 answer
Sqlite3 read only
SQL
0 vote204 views1 answer
Mysql récupérer le code création de vue
SQL
0 vote207 views1 answer
Install sql server in ubuntu 20.04
SQL