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

13 votes180 views4 answers
Mysql select last 10 rows
SQL
0 vote189 views1 answer
Mysql Like(searching in the string)
SQL
1 vote189 views1 answer
Sqlite3 read only
SQL
1 vote187 views1 answer
Convert varchar to int in sqlite
SQL
0 vote177 views2 answers
Mysql updating multiple column values from array variable
SQL
0 vote189 views1 answer
Get schema of table sql
SQL
0 vote193 views1 answer
Sparql list all graphs
SQL
0 vote190 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
5 votes203 views1 answer
Oracle nls instance
SQL
0 vote189 views1 answer
Sql xampp gabungan nama awal dan akhir
SQL