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 vote123 views1 answer
Oracle schema size
SQL
-1 vote127 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
1 vote123 views1 answer
Postgresql how to show table names
SQL
8 votes124 views2 answers
Between operator
SQL
1 vote118 views2 answers
Snowflake alter column data type
SQL
0 vote124 views2 answers
Dbms transaction tutorialspoint
SQL
1 vote136 views3 answers
SELECT * FROM
SQL
8 votes144 views2 answers
Oracle undo usage
SQL
1 vote118 views1 answer
Wherein mysql
SQL
7 votes119 views1 answer
Minecraft forge server host
SQL