mysql> select * from pet;
+-------+-------+---------+------+------------+-------+
| name | owner | kind | sex | birth | death |
+-------+-------+---------+------+------------+-------+
| buffy | chen | bird | NULL | 1997-12-09 | NULL |
| fang | james | hamster | f | 1999-11-11 | NULL |
| smth | chen | bird | NULL | 1997-12-09 | NULL |
| aa | chen | dog | m | 1977-11-11 | NULL |
| bb | chen | dog | f | 1977-11-11 | NULL |
| cc | chen | cat | m | 1977-11-11 | NULL |
| dd | chen | cat | f | 1977-11-11 | NULL |
| ee | chen | bird | m | 1977-11-11 | NULL |
| ff | chen | bird | f | 1977-11-11 | NULL |
| gg | chen | nn | m | 1977-11-11 | NULL |
| hh | chen | nn | f | 1977-11-11 | NULL |
| kk | chen | mm | m | 1977-11-11 | NULL |
| ww | chen | mm | f | 1977-11-11 | NULL |
+-------+-------+---------+------+------------+-------+
13 rows in set (0.00 sec)
mysql> select p1.name, p1.sex, p2.name, p2.sex, p1.kind from pet as p1, pet as p2 where p1.kind=p2.kind and p1.sex='f' and p2.sex='m';
+------+------+------+------+------+
| name | sex | name | sex | kind |
+------+------+------+------+------+
| bb | f | aa | m | dog |
| dd | f | cc | m | cat |
| ff | f | ee | m | bird |
| hh | f | gg | m | nn |
| ww | f | kk | m | mm |
+------+------+------+------+------+
阅读(437) | 评论(0) | 转发(0) |