INET_ATON() function in MySQL

Last Updated : 14 Dec, 2020

INET_ATON() :

This function in MySQL takes the dotted-quad representation of an IPv4 address as a string and returns the numeric value of the given IP address in form of an integer. If the input address is not a valid IPv4 address this function returns NULL. The return address is calculated by the following formula :

If the given input IPv4 address is a.b.c.d then the return value a×256³+ b×256²+ c×256¹ + d

Syntax :

INET_ATON(expr)

Parameter :

This method accepts only one parameter.

expr – Input IPv4 address represented by a string.

Returns :

It returns the numeric value of a given IPv4 address.

Example-1 :

Checking the equivalent integer representation for the following address “1.6.5.0” with the help of INET_ATON Function. As it is a valid IPv4 address we will get results in an integer.

SELECT INET_ATON('1.6.5.0')  AS AddressInInteger ;

Output :

ADDRESSININTEGER
17171712

Example-2 :

Checking the equivalent integer representation for the following address “::1.6” with the help of INET_ATON Function. As it is not a valid IPv4 address we will get NULL.

 SELECT INET_ATON('::1.6')  AS AddressInInteger ;

Output :

ADDRESSININTEGER
NULL

Example -3 :

Checking the equivalent integer representation for the following address “115.16.55.255” with the help of INET_ATON Function. As it is a valid IPv4 address we will get results in an integer.

 SELECT INET_ATON('15.16.55.255')  AS AddressInInteger ;

Output :

ADDRESSININTEGER
252721151

Example-4 :

Checking the equivalent integer representation for the following IPv6 address “fdfe::5a55:caff:fefa:9089” with the help of INET_ATON Function.

SELECT INET_ATON('fdfe::5a55:caff:fefa:9089')  AS AddressInInteger ;

Output :

ADDRESSININTEGER
NULL

INET_NTOA() function in MySQL

jana_sayantan

Improve

Article Tags :

Similar Reads

INET6_ATON() function in MySQL

This function in MySQL takes a dotted representation of an IPv4 or IPv6 address and returns a binary string that represents the numeric value of the address in network byte order. If the input address is not a valid IPv4 or IPv6 address this function returns NULL. Syntax : INET6_ATON(expr) Parameter

2 min read

INSERT() function in MySQL

INSERT() : This function in MySQL is used for inserting a string within a string, removing a number of characters from the original string. Syntax : INSERT(str, pos, len, newstr) Parameters : This method accepts four parameter. str - Original string in which we want to insert another string. pos - T

2 min read

LEFT() Function in MySQL

The LEFT() function in MySQL is used to extract a specified number of characters from the left side of a given string. It uses its second argument to decide, how many characters it should return. Syntax: LEFT (str, len)Parameter: This function accepts two parameters as mentioned above and described

1 min read

INET_NTOA() function in MySQL

INET_NTOA() : This function in MySQL takes the IPv4 address in network byte order and then it returns the address as a dotted-quad string representation. This function returns NULL if the input address is an invalid IPv4 address. Syntax : INET_NTOA(expr) Parameter : This function accepts only one pa

2 min read

LN() Function in MySQL

LN() function : It is the function in MySQL is used to calculate the natural logarithm of a specific number with base e . The number must be greater than 0, otherwise it will return NULL. Syntax : LN(X) Parameter : LN() function accepts one parameter as mentioned above in the syntax and described be

2 min read

COUNT() Function in MySQL

The COUNT() function in MySQL is a versatile aggregate function used to determine the number of rows or non-NULL values that match a specific condition in a query. It can be applied to an entire table or a particular column and is widely used in database operations to analyze the volume of data in a

3 min read

LEAST() Function in MySQL

The LEAST() function in MySQL is a versatile tool that returns the smallest (minimum) value from a list of expressions. It can be used with numbers, strings, or even columns of data to find the minimum value according to their data type. In this article, We will learn about LEAST() Function in MySQL

4 min read

INET6_NTOA() function in MySQL

INET6_NTOA() : This function in MySQL takes an IPv6 or IPv4 network address represented in numeric form as a binary string and it returns the string representation of the address as a string in the connection character set. It returns NULL if the address is not valid. Syntax : INET6_NTOA(expr) Param

2 min read

MONTH() function in MySQL

MySQL MONTH() function returns the month from the given date. It returns a month value between 1 and 12 or returns 0 when the month part of the date is 0. It's a useful SQL function for date manipulation and analysis, particularly when dealing with reports or queries that require month-based groupin

3 min read

BIT_LENGTH() Function in MySQL

BIT_LENGTH() function in MySQL is used to find the length of a given string in bits. The input string can be a character string or number string. Syntax : BIT_LENGTH(str) Parameter : Required. str : A string whose bits length to be calculated. Returns : It returns the length of a given string in bit

1 min read