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

4 votes284 views2 answers
Show all database inside postgresql
SQL
1 vote266 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL
0 vote272 views1 answer
Sql select by content lenght
SQL
0 vote274 views1 answer
Convert int to varchar sql
SQL
0 vote277 views1 answer
SQL loop with cursor
SQL
4 votes264 views2 answers
Sql select except null
SQL
11 votes272 views2 answers
Set default column value sql
SQL
0 vote276 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL
1 vote284 views1 answer
Psql connections
SQL
1 vote273 views1 answer
Xampp import sql file command line
SQL