Consider following table:
考虑下表:
+----+-------+--------------+
| id | name | info |
+----+-------+--------------+
| 1 | Chris | NULL |
| 2 | Den | some info |
| 3 | Bob | another info |
| 4 | Bob | NULL |
+----+-------+--------------+
+----+-----