How to copy data in sql

Migrate sql table another database

INSERT INTO dbo.YourTableNameHere
   SELECT *
   FROM [SourceServer].[SourceDatabase].dbo.YourTableNameHere

How to copy data in sql

INSERT INTO my_table my
SELECT * FROM another_table an
WHERE an.col1 > 10;

INSERT INTO my_table (colA, colB) 
SELECT an.col1 AS colA, an.col2 AS colB FROM another_table an
WHERE an.col1 > 10;

Similar codes

1 vote144 views1 answer
Mysqlworkbench Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
2 votes132 views1 answer
Match in sql server
SQL
6 votes137 views2 answers
Mysql set primary key
SQL
0 vote139 views1 answer
Change date format in oracle query
SQL
1 vote150 views1 answer
Show structure of table in sql
SQL
31 votes149 views4 answers
How to get duplicate records with multiple field in sql
SQL
6 votes137 views3 answers
How to delete table sqlite
SQL
0 vote134 views1 answer
Lost connection to mysql
SQL
0 vote148 views1 answer
Extract sql from query object sqlalchemy
SQL
0 vote188 views1 answer
T-sql delete view if exists
SQL