sql语句,把一张表里的数据,和特定数据(固定常量)新插入另一张表 ,,, from wm_jobpoint INSERT INTO wm_department(departmentcode,departmentname,provincecode,citycode,countycode,longitude,latitude) SELECT p.id,p.countyname, p.provincecode,p.citycode,p.countycode,p.longitude,p.latitud