Posted By

zingo on 02/01/08


Tagged

mysql sql diff


Versions (?)

Who likes this?

4 people have marked this snippet as a favorite

melling
uisluu
g8rpal
Beppoi


Differences between two Tables


 / Published in: SQL
 

URL: http://blog.256bit.org/archives/441-Den-Unterschied-zwischen-2-Tabellen-herausfinden.html

  1. SELECT 'tabelle1' Tabelle, a.* FROM (
  2. SELECT * FROM tabelle1
  3. MINUS
  4. SELECT * FROM tabelle2
  5. ) a
  6. UNION
  7. SELECT 'tabelle2' Tabelle, b.* FROM (
  8. SELECT * FROM tabelle2
  9. MINUS
  10. SELECT * FROM tabelle1
  11. ) b

Report this snippet  

You need to login to post a comment.