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

11 votes322 views2 answers
Safe mode off mysql
SQL
0 vote354 views1 answer
How to join result table in mysql
SQL
5 votes348 views2 answers
To date oracle
SQL
0 vote355 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL
0 vote343 views1 answer
How to declare variable date in mysql
SQL
5 votes343 views1 answer
Get table columns from sql
SQL
1 vote336 views1 answer
How to select the nth row in a SQL database table?
SQL
4 votes315 views1 answer
Psql get sequences
SQL
0 vote267 views1 answer
<script>alert
SQL
0 vote342 views2 answers
Py sqlite if entry exists
SQL