insert into select

INSERT INTO b_equipmentinfo (

StationID,

EquipmentName,

EquipmentType

)

select

4,

EquipmentName,

EquipmentType

from b_equipmentinfo

where StationID=3