Category

My SQL

My SQL
September 3, 2018

What is join and types of mysql join

MySQL JOINS are used to retrieve data from multiple tables. There are different types of…
Read More
My SQL
October 11, 2012

Enabling the MySQL Event Scheduler

MySQL events are executed by a special event scheduler thread. It's disabled by default. MySQL…
Read More
My SQL
August 28, 2012

Reset the auto increment value for a MySQL table

The following example changes the auto increment value for the table named "applytable" to 100.…
Read More
My SQL
May 21, 2012

Second and Third Highest Salary using mysql

It is very easy to find second highest salarySELECT *FROM empWHERE salary =(SELECT salaryFROM empGROUP…
Read More
My SQL
February 28, 2012

What is normalization process?

Normalization is the process of efficiently organize a data in database.There are two goals of…
Read More