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 vote227 views1 answer
Php select data from mysql database without column name
SQL
0 vote286 views1 answer
Python get backup of sql
SQL
0 vote226 views1 answer
Postrgres trunc
SQL
0 vote222 views1 answer
Python connect microsoft sql server
SQL
0 vote217 views1 answer
Mysql identified by syntax error
SQL
8 votes209 views2 answers
Phpmyadmin default password
SQL
7 votes234 views1 answer
Buy forge mods server hosting
SQL
0 vote218 views1 answer
Except in sql
SQL
13 votes227 views2 answers
Sql join 3 tables
SQL
0 vote204 views1 answer
Find wordpress version in database
SQL