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, 251🔥, 0💬
Popular Posts:
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...