The GROUP BY Statement in SQL is used to arrange identical data into groups with the help of some functions. To select the first row… Read More
Tag Archives: SQLmysql
At the point when an application calls SQLExecute or SQLExecDirect, the driver recovers the data for any boundaries bound with SQLBindParameter from capacity areas in… Read More
There may be a number of occasions where you need to create an exact copy of an already defined (or created) table. MySQL enables you… Read More
MySQLi (MySQL Improved) provides procedural and object oriented interface to data and its management. The i extension MySQL functions allows the user to access its… Read More
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… Read More
The MySQL CAST() function is used for converting a value from one datatype to another specific datatype. The CAST() function accepts two parameters which are… Read More
The MySQL SESSION_USER() function is used for returning the current user name and host name for the MySQL connection being used by the user. The… Read More
The MySQL COALESCE() function is used for returning the first non-null value in a list of expressions. If all the values in the list evaluate… Read More
The MySQL IF() function is used for validating a condition. The IF() function returns a value if the condition is TRUE and another value if… Read More
The MySQL BINARY function is used for converting a value to a binary string. The BINARY function can also be implemented using CAST function as… Read More
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… Read More
The MySQL CONVERT() function is used for converting a value from one datatype to a different datatype. The MySQL CONVERT() function is also used for… Read More
The MySQL Version() function is used for returning the current version of the MySQL database. This function uses the utf8 character set. Generally, there is… Read More
The MySQL NULLIF() function is used for the comparison of two expressions. The NULLIF() function returns NULL if both the expressions are equal, else it… Read More
The MySQL ISNULL() function is used for checking whether an expression is NULL or not. This function returns 1 if the expression passed is NULL,… Read More
