[mysql]SQL查询存在A表但不存在B表的数据

select * from ti_road_node_code a where a.road_node_id not in (select en_road_node_id from ti_road_node_relation b)

• 15毫秒

select * from ti_road_node_code a left join ti_road_node_relation b where a.road_node_id =en_road_node_idand isnull(b.ex_road_node_id)- 报错

select a.* from ti_road_node_code a left join ti_road_node_relation b on a.road_node_id =b.en_road_node_id whereisnull(b.ex_road_node_id)

• 282毫秒
  • select a.* from ti_road_node_code a left join ti_road_node_relation b on a.road_node_id =b.en_road_node_id where
  • isnull(b.en_road_node_id)
  • 一样

SELECT a.* FROM ti_road_node_code aWHERE NOT EXISTS (SELECT 1 FROM ti_road_node_relation b WHERE b.en_road_node_id = a.road_node_id)

• 540毫秒