復制代碼 代碼如下:

insert into t2(id,name,pwd)
select id,name,pwd from t1

復制代碼 代碼如下:

select * into t2 from t1