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 vote281 views2 answers
Sql query inner join 3 tables
SQL
4 votes266 views3 answers
Order by value mysql
SQL
1 vote280 views1 answer
Use of now() in mysql
SQL
3 votes271 views2 answers
Truncate all tables
SQL
12 votes259 views2 answers
Delete all data in neo4j
SQL
0 vote281 views1 answer
SQL SELECT TOP Equivalent in MySQL
SQL
0 vote296 views1 answer
Mysql change default collation
SQL
7 votes289 views2 answers
Where keyword sql
SQL
0 vote272 views1 answer
Enable full text search mysql
SQL
0 vote268 views1 answer
Count number of entires by months sql
SQL