How to REORG a table in MySQL
Answer:
In MySQL, the only way to REORG a table is to export the data, e.g. using mysqldump, then import the data into MySQL again.
While other database such as Oracle provides a more handy way to do it.
Feb 122008
May 132007
Convert IP address to unsigned integer in MySQL
Answer:
To convert an IPv4 address string, such as 127.0.0.1 to an unsigned integer, you can use the INET_ATON function in MySQL.
mysql> SELECT INET_ATON('127.0.0.1');
+------------------------+
| INET_ATON('127.0.0.1') |
+------------------------+
| 2130706433 |
+------------------------+
