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 vote334 views1 answer
Insert to first table if field A equals field B from a second table using sql
SQL
0 vote353 views1 answer
Python mysql executemany
SQL
7 votes411 views2 answers
How to create index mysql
SQL
0 vote370 views1 answer
List column names of multiple tables psql
SQL
10 votes380 views2 answers
Select nextval from sequence oracle
SQL
-1 vote331 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
1 vote407 views3 answers
Date_add mysql
SQL
4 votes357 views1 answer
Id primary key auto generated
SQL
0 vote361 views1 answer
Enlever les doubles espaces dans les tables postgresql
SQL
0 vote407 views1 answer
Delete from IN subquery
SQL