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

6 votes213 views3 answers
Create database mysql utf8
SQL
4 votes187 views1 answer
Select first and last row sql
SQL
0 vote194 views1 answer
Create dump file mysql workbench
SQL
0 vote207 views2 answers
Add new column after in sql
SQL
1 vote190 views1 answer
Psql filed name alter
SQL
1 vote326 views3 answers
Sql subquery
SQL
0 vote207 views1 answer
Sqlite trim
SQL
3 votes197 views2 answers
Postgresql select all column names
SQL
20 votes187 views2 answers
Counting in sql
SQL
1 vote186 views1 answer
Mysql history command
SQL