August 2017
Beginner to intermediate
284 pages
6h 51m
English
Run the following command on the MySQL console to calculate the page hit from each country:
mysql> select country, count(*) from apachelog group by country; +---------------------------+----------+ | country | count(*) | +---------------------------+----------+ | Asia/Pacific Region | 9 | | Belarus | 12 | | Belgium | 12 | | Bosnia and Herzegovina | 12 | | Brazil | 36 | | Bulgaria | 12 | | Canada | 218 | | Europe | 24 | | France | 44 | | Germany | 48 | | Greece | 12 | | Hungary | 12 | | India | 144 | | Indonesia | 60 | | Iran, Islamic Republic of | 12 | | Italy | 24 | | Japan | 12 | | Malaysia | 12 | | Mexico | 36 | | NA | 10 | | Nepal | 24 | | Netherlands | 164 | | Nigeria | 24 | | Puerto Rico | 72 ...
Read now
Unlock full access