title: How to find difference between two MySQL tables using MySQL statement?
body: <p>I have two tables called MytableA and MytableB. MytableA holds 609 rows and MytableB holds 607 rows. Both Rows have same structure. I just want to find out what imageURL(s) exist in MytableA that don't exist in MytableB and display those missing rows? Could anyone tell me what is the MySQL statement to display those rows that are missing in MytableB?</p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS `MytableA` (
    `ID` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(32) DEFAULT NULL,
    `bio` varchar(90) DEFAULT NULL,
    `website` varchar(90) DEFAULT NULL,
    `profile` varchar(90) NOT NULL,
    `fullname` varchar(250) DEFAULT '',
    `diffId` varchar(250) NOT NULL DEFAULT '',
    `imageUrl` varchar(250) NOT NULL DEFAULT '',
    `PageURL` varchar(250) NOT NULL DEFAULT '',
    `CreatedTime` varchar(250) NOT NULL DEFAULT '',
    `imageTags` varchar(250) NOT NULL DEFAULT '',
    `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    PRIMARY KEY (`ID`)
  )
  </code></pre>