How to track pageviews and unique visitors with MySQL
Create a table:
```sql
create table page_views (id VARCHAR(50), views INTEGER) primary key id;
```
Use the ON DUPLICATE declaration:
```sql
insert into page_views (id, views) values ('/', 1) on duplicate key update views = views + 1;
```
Idea from