/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

6 votes173 views2 answers
WHERE value IS sql
SQL
1 vote139 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception
SQL
-1 vote134 views3 answers
Check table exist postgresql
SQL
1 vote161 views1 answer
Sql set auto increment back to 0
SQL
0 vote150 views1 answer
Desinstaller mysql sur ubuntu definitivement
SQL
0 vote148 views2 answers
How covert into int in maria db
SQL
0 vote136 views1 answer
Mariadb datetime change to microseconds
SQL
2 votes183 views1 answer
Sql compare strings
SQL
0 vote129 views1 answer
What is logical database schema
SQL
0 vote163 views1 answer
Postgressql uuid
SQL