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

1 vote325 views1 answer
Mysql show table character set
SQL
2 votes330 views1 answer
Get hour from date sql
SQL
17 votes324 views4 answers
Set mysql Password
SQL
0 vote335 views1 answer
How to fetch unique records from two tables
SQL
0 vote339 views1 answer
How to alter length character varying postgres
SQL
0 vote399 views1 answer
Sql datum formatieren
SQL
10 votes357 views4 answers
Else if mysql
SQL
0 vote340 views3 answers
Sql drop all tables
SQL
0 vote363 views3 answers
Call to undefined function mysql_connect()
SQL
0 vote324 views2 answers
Sql if empty then
SQL