help,help!!

Question

insert into    equipment(equipment_id,type,title,usedepartment,buydate,nianxian))
select estno,subject,name,est_sub,use_branch,add_date,years from increace where estno='2S-D001-D014'

Answer 1

or
select estno equipment_id,subject ,name,est_sub,use_branch,add_date,years  into equipment from increace where estno='2S-D001-D014'

Answer 2

insert into equipment(equipment_id,type,title,usedepartment,buydate,nianxian)
    select estno,subject,name,est_sub,use_branch,add_date,years from increace where estno='2S-D001-D014'

Answer 3

select estno,subject,name,est_sub,use_branch,add_date,years into 新表 from increace where estno='2S-D001-D014'