How to reset auto-increment value of a column in MySql.
In MySQL, we can define a column as primary key with an auto-increment index. Every time a new row is inserted it increments the value by 1. By default, an auto-increment column is a primary key of a table.
How to Convert Timestamp to Date and Time format in MySql. As Timestamp is not a human readable format, you can easily convert Timestamp to Date and Time format using an inbuilt function in MySql. If you find difficulty in converting
If this tutorial, We’ll learn how to convert a timestamp to human readable date and time format.
How to use IF condition in MySql with a select statement. In this tutorial, You are going to learn how to use IF condition in MySql to select column value conditionally.
If Condition in MySql
How to use FIND_IN_SET() function in MySql . This tutorial explain how to use this in-built function to search for values within a comma separated values.
While working on some module i came across with MySql FIND_IN_SET() function. In my case i have to pull all the records whose status match with status list separated with comma are stored in table.