How to Reset an Auto-Increment Value of a Column in MySql

mysqlHow 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

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

Subscribe Our Tutorials

Get Latest Updates on Facebook

If this tutorial, We’ll learn how to convert a timestamp to human readable date and time format.

FIND_IN_SET() Function 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.