Database statement Building table, copy data table

1. Database Build Table statement

create table tb_People(id integer primary key, Name varchar(255), Sex varchar(255))

2. Copy data table with database

sql:insert into table1 select*from table2(完全拷贝)insert into table1 select distinct*from table2(不重复拷贝);insert into table1 select top 10*from table2(前10条拷贝)

3. Do not copy data tables in the same database

DB1, DB2 for two databases, Tb_boy, Tb_girl table for the first two databases
Sql:

insert into DB1.tb_boy select*from DB2.tb_girlinsert into  DB1.tb_boy select*from DB2.tb_girl(完全拷贝)insert into  DB1.tb_boy select distinct*from DB2.tb_girl(不重复拷贝);insert into  DB1.tb_boy select top 10*from DB2.tb_girl(前10条拷贝)

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Database statement Building table, copy data table