mysql中把一张表的数据转移到另一张表中

insert into 
huzhu_info(
h_id,h_name,h_idcard,h_bank,
h_jstype,h_bh,h_jiangjin,qianzitype,
deptid,deptname,vill_id,vill_name
) 
select 
numberd,names,idcars,bankerds,
jian,numberd,jiang,qianzitype,
deptId,deptName,villId,villName
from sheet2;