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

3 votes109 views2 answers
Sqlite print all column names
SQL
3 votes101 views2 answers
WhereIn SQL
SQL
6 votes110 views3 answers
Check if string contains substring sql
SQL
0 vote95 views1 answer
Call function in query sql server
SQL
2 votes108 views1 answer
Date conversion in mysql column
SQL
4 votes102 views2 answers
Insert current date in mysql
SQL
0 vote105 views1 answer
How to know if table in rigt or left in sql
SQL
1 vote107 views1 answer
Oracle list datafiles in tablespace
SQL
12 votes99 views4 answers
Mysql version
SQL
10 votes110 views1 answer
Oracle dependencies table
SQL