/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 vote320 views1 answer
Linux upload database to mysql
SQL
0 vote337 views1 answer
Sql orcale i forgot what my name & password was
SQL
0 vote353 views1 answer
Mysql utc timestamp
SQL
5 votes397 views1 answer
Oracle source query
SQL
0 vote349 views1 answer
Aktor yang pernah terlibat lebih dari 3 film di sql
SQL
1 vote351 views1 answer
Psql datetime grather than
SQL
2 votes342 views2 answers
Checking data type in sql server
SQL
0 vote375 views1 answer
Oarcale list objects
SQL
4 votes354 views1 answer
Sql quote in string
SQL
4 votes364 views3 answers
Is not null sql
SQL