title: How to translate this MSSQL query using "EXCEPT" to MySQL?
body: <p>The problem is with "EXCEPT" which is not supported by MySQL. The goal is to find all rows where all columns (except id) are not identical.</p>
  
  <pre><code>SELECT B.*, 'modified'  AS 'changetype'
  FROM (
          SELECT * FROM table1 
          EXCEPT
          SELECT * FROM table2 
  ) S1
  INNER JOIN table2  B ON S1.id = B.id;
  </code></pre>