/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

1 vote278 views3 answers
Java.sql.sqlexception: access denied for user
SQL
0 vote323 views1 answer
How to find unique element in sql
SQL
0 vote273 views2 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'world.admin_tasks' doesn't exist
SQL
0 vote276 views1 answer
Can't connect to postgresql mac os
SQL
0 vote266 views1 answer
Nth max in my sql
SQL
3 votes274 views2 answers
Oracle drop column
SQL
0 vote275 views1 answer
Sql select most frequent value in column
SQL
2 votes306 views3 answers
Postgres json to string
SQL
11 votes279 views1 answer
Oracle insert into where
SQL
0 vote288 views1 answer
Uncheck constraints and delete from table
SQL