/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

5 votes303 views1 answer
Ascending order and where in sql
SQL
3 votes348 views4 answers
Postgresql change timezone on timestamp without timezone
SQL
0 vote340 views2 answers
Select a row include list of array with join two table SQL
SQL
0 vote303 views1 answer
Low level operator in dbms
SQL
0 vote323 views1 answer
Postgres populate table from another table
SQL
0 vote332 views2 answers
Call to undefined function mysql_query()
SQL
0 vote358 views1 answer
Stored procedure function relation
SQL
0 vote285 views1 answer
Import sql mysql ubuntu
SQL
0 vote329 views1 answer
Query by column for substring sql
SQL
1 vote305 views1 answer
Oracle create program if no exists
SQL