[107150] in North American Network Operators' Group

home	help	back	first	fref	pref	prev	next	nref	lref	last	post

Re: interger to I P address

daemon@ATHENA.MIT.EDU (Michael Holstein)
Wed Aug 27 12:16:04 2008

Date: Wed, 27 Aug 2008 12:16:51 -0400
From: Michael Holstein <michael.holstein@csuohio.edu>
To: nanog@nanog.org
In-Reply-To: <48B57CB6.8030500@ias.edu>
Errors-To: nanog-bounces@nanog.org

In MySQL :

mysql> SELECT INET_NTOA(ip_in_decimal) AS ipa;

.. or the reverse :

mysql> SELECT INET_ATON('dotted.quad') AS ipn;

home	help	back	first	fref	pref	prev	next	nref	lref	last	post