When you work with complicated queries, especially ones which contain subqueries, it is easy to make a typo or misinterpret column name. While in many cases you will receive a
column not found error, sometimes you can get strange results instead.
Like finding 4079 countries in Antarctica:
mysql> select count(*) from City where CountryCode in (select CountryCode from Country […]Read more