且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何使用MySQL语句查找两个MySQL表之间的差异?

更新时间:2022-12-09 17:16:49

SELECT *
  FROM MyTableA
 WHERE imageURL NOT IN (SELECT imageURL FROM MyTableB)

也许有更快的方法,但这具有简洁的优点.

There may be faster ways to do it, but this has the merit of succinctness.