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() …
The MySQL NULLIF() Function With 5 Easy Examples Read More »