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 vote152 views1 answer
How to get first 10 records of a table in mysql
SQL
0 vote112 views1 answer
Prevent duplicate rows in postgres
SQL
1 vote134 views1 answer
Get count by weekly pivot table sql server
SQL
0 vote154 views1 answer
Sql server roles and users
SQL
0 vote142 views1 answer
Get current date data in mysql
SQL
10 votes97 views2 answers
Django mysql
SQL
0 vote141 views1 answer
Sql case sttement with set
SQL
3 votes162 views3 answers
1396(hy00) mysql error
SQL
0 vote97 views2 answers
Denormalization in sql
SQL
0 vote111 views1 answer
Store query result in variable sql
SQL