Add static route to windows

To add a static route to windows, do the following;

route add destination mask gateway metric interface

route add 23.128.16.0 255.255.240.0 23.128.16.1 IF 13

Note, in the above we are ignoring the metric.

The interface number can be found from;

netsh interface ipv4 show interfaces

Selecting distinct columns with MySQL

In the past I was sure it was not possible in MySQL to use DISTINCT on multiple columns, such as below;

SELECT DISTINCT a,b FROM my_table;

and have in the past, instead used something similar to the below as a workaround;

SELECT DISTINCT CONCAT (a,' ', b) FROM my_table;

However, it seems I am remiss and MySQL does indeed support DISTINCT on multiple columns.