[Level 2] How to get the difference between two tables.

Two table have the same data in echo column, how to get the difference between two tables.
You can use out join and constraint the condition.

Example:
mysql> create table table1 (id int, name varchar(32));
mysql> create table table2 (id int, name varchar(32));
mysql> insert into table1 values(1,'Stanley'),(2,'John'),(4,'Mary');
mysql> insert into table2 values(1,'Stanley'),(3,'Joseph'),(5,'Christy');

case 1: find the data in table1 but not in table2;
mysql> select * from table1 left join table2 on table1.id=table2.id where table2.id is null;

case 2: find the data in table2 but not in table1;
mysql> select * from table2 left join table1 on table2.id=table1.id where table1.id is null;

Wish this helps.

regards,
Stanley Huang

Comments

Post a Comment

Popular posts from this blog

[Level 1] Rar tool for Solaris.

Sometimes we will got a rar compressed file from our friends, but there is no default tool in OpenSolaris to decompress the rar filess. We can got a Solaris Intel version from rarlab . The steps as the following: 1. down load the rar tools from rarlab. http://www.rarlab.com/rar_add.htm 2. uncompressed the source. # gunzip ./unrar-sol-intel.gz 3. move it to the location you used to. # mv /unrar-sol-intel.gz /usr/bin/unrar 4. try to decomprss # unrar x ./test.rar Wish this helps. regards, Stanley Huang
Read more

[Level 2] iif in Python

If you want to implement iif in Python, please refer to the following sample code: #!/bin/env python def iif(b): return 'It\'s True' if b else 'It\'s False' print iif(True) print iif(False) And the following sample, guess what will you get! #!/bin/env python b = True print 'b: %s' % 'Ture' if b else 'False' b = False print 'b: %s' % 'Ture' if b else 'False' Result: $ ./iif.py b: Ture False The second result is "False", not "b: False". Why??? Because the prededence of string concatenation is higher than if. Therefore you need to use () to make it correct. #!/bin/env python b = True print 'b: %s' % 'Ture' if b else 'False' b = False print 'b: %s' % ('Ture' if b else 'False') Wish this helps. regards, Stanley Huang
Read more