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

8 votes168 views1 answer
Oracle find text in functions
SQL
1 vote176 views1 answer
Mysql Case sum
SQL
0 vote176 views2 answers
Sql server set default value equal to auto increment
SQL
3 votes177 views2 answers
Oracle sql select all days between two dates except weekends
SQL
2 votes177 views1 answer
Sql percentage with % rounded down
SQL
4 votes162 views2 answers
Insert current date in mysql
SQL
2 votes206 views2 answers
Set value to null sql
SQL
0 vote177 views1 answer
How to export only procedures mysql
SQL
1 vote171 views1 answer
Mysql query where in select
SQL
2 votes173 views3 answers
How to check current user in mySQL
SQL