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

0 vote137 views1 answer
Sql server set complex constraints
SQL
1 vote133 views1 answer
Mysql random limit 1
SQL
47 votes213 views6 answers
Add column mysql
SQL
1 vote139 views2 answers
Oracle replace
SQL
0 vote129 views1 answer
Date diff sql
SQL
37 votes178 views6 answers
Mysql update
SQL
10 votes132 views1 answer
Create table oracle
SQL
0 vote153 views1 answer
Postgre query date
SQL
0 vote138 views1 answer
Conda install pymysql "windows"
SQL
2 votes104 views1 answer
Latest record in sql
SQL