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

2 votes202 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL
0 vote208 views1 answer
Mysql add to number
SQL
3 votes316 views3 answers
Mysql get table size
SQL
3 votes197 views1 answer
Oracle rollback
SQL
0 vote217 views1 answer
Postgresql import a database of gzip
SQL
0 vote206 views1 answer
Postgres type equivalent to timespan c#
SQL
0 vote204 views4 answers
Mysql select bottom 10 rows
SQL
2 votes219 views2 answers
Mysql alter column default
SQL
2 votes252 views2 answers
Asp.net core with postgresql deploy on ubuntu
SQL
14 votes1.3K views1 answer
Sql value of string
SQL