This post is collection of mysql query to perform particular task, this will make you life easy. NOTE : Basically this is not good practis to work with database directlly for live project. Make sur…