Advanced Search

Return to Snippet

Revision: 4980
at February 1, 2008 04:26 by zingo
Initial Code 
SELECT 'tabelle1' Tabelle, a.* FROM (
SELECT * FROM tabelle1
MINUS
SELECT * FROM tabelle2
) a
UNION
SELECT 'tabelle2' Tabelle, b.* FROM (
SELECT * FROM tabelle2
MINUS
SELECT * FROM tabelle1
) b
Initial URL 
http://blog.256bit.org/archives/441-Den-Unterschied-zwischen-2-Tabellen-herausfinden.html
Initial Description 

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Differences between two Tables

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
mysql, sql

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL