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

3 votes185 views1 answer
Sql set null
SQL
24 votes199 views4 answers
How to add column sql
SQL
0 vote210 views1 answer
Sql alter column name sql server
SQL
0 vote189 views1 answer
Login failed for login due to trigger execution
SQL
0 vote224 views1 answer
Oracle webcenter content search enginer
SQL
3 votes221 views1 answer
Flutter sqlite auto incrementing id primary key
SQL
1 vote201 views1 answer
Mysql column start with string
SQL
0 vote207 views1 answer
How to display value of variable in mysql
SQL
12 votes203 views4 answers
Import mysql database command line linux
SQL
4 votes198 views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL