Kabir Campwala

The MySQL LAST_INSERT_ID() function of MySQL does exactly as it reads. It will return the latest ID of the AUTO_INCREMENT column. This can be a useful little function to find out the latest ID of the AUTO_INCREMENT column. The LAST_INSERT_ID() function can be used without an expression and also with an expression. This function when […]

When working with a number different of data types the MySQL CAST() function comes in handy. It will help in casting the specified expressions to a specified data type. Typecasting refers to the process of manually changing the data type of an expression. The CONVERT() function is equivalent of the CAST() Function. To understand this

The MySQL NULLIF Function is very useful when it comes to checking if two values are equal and getting a value in return. It is categorized as a Flow Control Function. A Flow Control Function means you can control the flow of the program based on the return value given by a function. The NULLIF()