Showing posts with label aggregation. Show all posts
Showing posts with label aggregation. Show all posts

Saturday, May 17, 2014

Subnet calculation using pure mysql

You can easily aggregate your records by subnets using mysql thanks to bitwise operators, an inet_aton (ascii to number function) and some thinking...

Here you go: