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 votes126 views1 answer
Ssh mysql port forwarding
SQL
0 vote138 views1 answer
How to select a row in sql
SQL
0 vote141 views1 answer
Custom row number
SQL
0 vote136 views1 answer
Sql select most frequent value in column
SQL
0 vote139 views1 answer
How to put is null in where in clause
SQL
2 votes137 views1 answer
Mysql create user with mysql_native_password
SQL
0 vote127 views1 answer
Mysql add to value
SQL
3 votes130 views1 answer
Mysql insert on dupèlicate
SQL
0 vote126 views2 answers
Soql last year
SQL
1 vote148 views1 answer
Ubuntu access database from terminal
SQL