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

3 votes151 views1 answer
Create a table with an id in mysql
SQL
0 vote177 views1 answer
Select top values sql
SQL
0 vote164 views1 answer
Docker open terminal mysql server
SQL
1 vote173 views5 answers
What is in operator in sql
SQL
1 vote216 views1 answer
Oracle transaction rollback not working
SQL
0 vote207 views1 answer
Oracle create package specification
SQL
1 vote159 views1 answer
Postgres count string length
SQL
0 vote168 views1 answer
Sql server python connection
SQL
0 vote164 views1 answer
Tsql table column constraint must be uppercase
SQL
1 vote188 views1 answer
How to fetch data in between startfromdate to starenddate in sql
SQL