Collections:
INET6_NTOA() - IPv6 Address Number to String
How to convert an IPv6 address from number format to string using the INET6_NTOA() function?
✍: FYIcenter.com
INET6_NTOA(int) is a MySQL built-in function that converts an IPv6 address from number format to string. For example:
SET @ipv6 = UNHEX('FDFE0000000000005A55CAFFFEFA9089'); SELECT HEX(@ipv6), INET6_NTOA(@ipv6); -- +----------------------------------+---------------------------+ -- | HEX(@ipv6) | INET6_NTOA(@ipv6) | -- +----------------------------------+---------------------------+ -- | FDFE0000000000005A55CAFFFEFA9089 | fdfe::5a55:caff:fefa:9089 | -- +----------------------------------+---------------------------+
INET6_NTOA also works on IPv4 addresses. For example:
SET @ipv4 = UNHEX('0A000509'); SELECT HEX(@ipv4), INET6_NTOA(@ipv4); -- +------------+-------------------+ -- | HEX(@ipv4) | INET6_NTOA(@ipv4) | -- +------------+-------------------+ -- | 0A000509 | 10.0.5.9 | -- +------------+-------------------+
Reference information of the INET6_NTOA() function:
INET6_NTOA(int): ip Converts an IPv6 address from number format to string. Arguments, return value and availability: int: Required. The IPv6 address in number format. ip: Return value. The IPv6 address as a string. Available since MySQL 4.0.
Related MySQL functions:
⇒ IS_FREE_LOCK() - Checking Lock Status
⇐ INET6_ATON() - IPv6 Address String to Number
2023-12-17, 262🔥, 0💬
Popular Posts:
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
Collections: Interview Questions MySQL Tutorials MySQL Functions Oracle Tutorials SQL Server Tutoria...