/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 vote311 views1 answer
Sql orcale i forgot what my name & password was
SQL
0 vote318 views1 answer
Default password for mysql_secure_installation in mac
SQL
0 vote346 views1 answer
Postgresql extract hour and minutes from timestamp
SQL
1 vote330 views1 answer
Mysql data from file
SQL
0 vote360 views1 answer
Psql check table fields
SQL
14 votes334 views3 answers
This is incompatible with sql_mode=only_full_group_by laravel
SQL
0 vote310 views1 answer
Systemverilog unique constraint unique values
SQL
1 vote327 views3 answers
Drop unique key constraint in sql server
SQL
0 vote345 views1 answer
Is there any limit of using joins in single mysql query ?
SQL
0 vote310 views1 answer
Change default schema sql server
SQL