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, 258🔥, 0💬
Popular Posts:
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...