/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

10 votes200 views3 answers
How to fetch first 5 characters in sql
SQL
-1 vote205 views1 answer
SQL query to convert DD/MM/YYYY to YYYY-MM-DD
SQL
0 vote258 views2 answers
Return the number of records in a single table mysql
SQL
0 vote228 views1 answer
Count column of tables psql
SQL
1 vote182 views1 answer
Sql eliminare un record
SQL
22 votes196 views3 answers
Remove all records from table mysql
SQL
0 vote191 views2 answers
Oracle chain rules
SQL
1 vote191 views1 answer
Search for tables with name postgresql
SQL
0 vote218 views1 answer
Sql server beginning of month
SQL
0 vote191 views1 answer
If null don't update
SQL