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

2 votes316 views1 answer
Mysql select default if null
SQL
3 votes369 views1 answer
Mysql cli connect with password
SQL
0 vote291 views2 answers
MySQL top percent
SQL
0 vote277 views1 answer
Oracle list dblink
SQL
0 vote313 views1 answer
Mysql error 1251
SQL
0 vote349 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
8 votes410 views2 answers
Select current_timestamp - interval '3 days';
SQL
3 votes302 views2 answers
How to modify rows in SQL Server
SQL
1 vote315 views1 answer
Search for replace in mysql
SQL
0 vote313 views2 answers
Nodejs mysql convert to plain object
SQL