删除路线站点关系
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。
原文:https://www.cnblogs.com/panchanggui/p/9552542.html