davinci 删除路线站点关系

 

 删除路线站点关系 

DELETE FROM tb_station_info_draw WHERE id in (SELECT stationId FROM tb_road_station_relation_draw WHERE cityId=283 AND roadId=46);

DELETE FROM tb_road_station_relation_draw WHERE cityId=283 AND roadId=46;

由于sql分开，要先执行1，再执行2。 

 

删除路线点

DELETE FROM tb_road_point_draw WHERE cityId=285 AND roadId=21;