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

9 votes162 views2 answers
Convert data type in sql
SQL
6 votes155 views3 answers
Mysql create database utf8
SQL
4 votes164 views1 answer
Describe table mysql
SQL
0 vote186 views1 answer
Mysql extract day from date leading zero
SQL
1 vote138 views1 answer
Local sql server
SQL
1 vote98 views1 answer
Metada in sql
SQL
4 votes154 views2 answers
Sqlalchemy_database_uri for mysql
SQL
1 vote182 views1 answer
Error cs1061 'dbcontextoptionsbuilder' does not contain a definition for 'usesqlserver'
SQL
-2 votes155 views1 answer
Remove root password mysql
SQL
2 votes141 views2 answers
Mysql user access to database
SQL