📄️ exists
The exists condition is used in combination with a subquery and is considered "to be met" if the subquery returns at least one row.
Other Functions
📄️ ignore
By using insert ignore statement, the rows with invalid data that cause the error are ignored and the rows with valid data are inserted into the table.
📄️ INET_NTOA
Converts a 32-bit integer to an IPv4 address.
📄️ INET_ATON
Converts an IPv4 address to a 32-bit integer.
📄️ ipv4_num_to_string
Converts a 32-bit integer to an IPv4 address.
📄️ ipv4_string_to_num
Converts an IPv4 address to a 32-bit integer.
📄️ RUNNING_DIFFERENCE
Calculates the difference between successive row values in the data block.
📄️ try_inet_aton
tryinetaton function is used to take 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.
📄️ try_inet_ntoa
tryinetntoa function is used to take the IPv4 address in network byte order and then it returns the address as a dotted-quad string representation.
📄️ try_ipv4_num_to_string
Converts a 32-bit integer to an IPv4 address.
📄️ try_ipv4_string_to_num
Converts an IPv4 address to a 32-bit integer.
📄️ TYPEOF
TYPEOF function is used to return the name of a data type.