MySQL | CONNECTION_ID( ) Function Last Updated : 25 Nov, 2019 Comments Improve Suggest changes Like Article Like Report The MySQL CONNECTION_ID() function is used for return the connection ID for a current connection in MySQL. The connection ID used to establish a connection to a database is unique for every connection among the connected clients. The CONNECTION_ID() function does not require any parameters or arguments. The value returned by the CONNECTION_ID() function is the same type of value as displayed in the ID column of the INFORMATION_SCHEMA.PROCESSLIST table. Syntax: CONNECTION_ID() Parameters Used: The CONNECTION_ID() function does not require any parameters or arguments. Return Value: The MySQL CONNECTION_ID() function returns an integer value which represents the unique current connection ID. Supported Versions of MySQL: MySQL 5.7 MySQL 5.6 MySQL 5.5 MySQL 5.1 MySQL 5.0 MySQL 4.1 MySQL 4.0 MySQL 3.23 Example: Implementing CONNECTION_ID() function. SELECT CONNECTION_ID(); Output: 1196078 Comment More infoAdvertise with us Next Article MySQL | CONNECTION_ID( ) Function S Shubrodeep Banerjee Follow Improve Article Tags : SQL mysql SQLmysql Similar Reads PHP mysqli_connect() Function The mysqli_connect() function in PHP is a fundamental tool for establishing a connection to a MySQL database. This function is crucial for PHP applications that need to interact with MySQL databases, enabling them to execute queries, retrieve data, and perform various database operations.In this art 3 min read MySQL | CONV( ) Function The MySQL CONV() function is used for converting a number from one numeric base system to another. The value returned by the CONV() function is in the form of a string value. It accepts three parameters which are the value to be converted, the current numeric base system and the numeric base system 2 min read INET_ATON() function in MySQL 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 f 2 min read 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 MySQL IF( ) Function The MySQL IF() function is a control flow function that returns different values based on the result of a condition. IF() Function in MySQLThe IF() function in MySQL returns a value if the condition is TRUE and another value if the condition is FALSE. The MySQL IF() function can return values that c 2 min read Like