INET6_NTOA(expr)

MySQL 8.4 🇮🇩 Bahasa Indonesia

Mengingat alamat jaringan IPv6 atau IPv4 direpresentasikan dalam bentuk numerik sebagai string biner, mengembalikan representasi string alamat sebagai string dalam kumpulan karakter koneksi. Jika argumennya bukan alamat yang valid, atau NULL, INET6_NTOA() mengembalikan NULL.

Syntax

MYSQL

CREATE TABLE t AS SELECT INET6_NTOA(expr) AS c1;

Contoh

Example

INET6_NTOA() has these properties:

MYSQL

CREATE TABLE t AS SELECT INET6_NTOA(expr) AS c1;

Example 2

It does not use operating system functions to perform conversions, thus the output string is platform independent.

MYSQL

CREATE TABLE t (c1 VARCHAR(39) CHARACTER SET utf8mb3 DEFAULT NULL);

Example 3

The return string has a maximum length of 39 (4 x 8 + 7). Given this statement:

MYSQL

SELECT INET6_NTOA(INET6_ATON('fdfe::5a55:caff:fefa:9089'));
'fdfe::5a55:caff:fefa:9089'
SELECT INET6_NTOA(INET6_ATON('10.0.5.9'));
'10.0.5.9'

SELECT INET6_NTOA(UNHEX('FDFE0000000000005A55CAFFFEFA9089'));
'fdfe::5a55:caff:fefa:9089'
SELECT INET6_NTOA(UNHEX('0A000509'));
'10.0.5.9'