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 votes128 views2 answers
Set database timezone mysql
SQL
3 votes86 views4 answers
Mysql delete duplicate rows
SQL
0 vote123 views1 answer
Mysql default timestamp value to be current timestamp
SQL
0 vote132 views1 answer
Get the previous column of a table in mysql
SQL
0 vote154 views1 answer
Alter owner in PostgreSQL
SQL
1 vote157 views2 answers
Laravel jwt generate token
SQL
2 votes133 views1 answer
Metasploit start postgresql
SQL
0 vote142 views1 answer
Consulta alias con inner join
SQL
6 votes221 views3 answers
Psql show columns of table
SQL
5 votes133 views1 answer
Commentaire table oracle
SQL