Mysql Date Sort
Mysql Date Sort is used to return the sort records or rows value in table.
Understand with Example
The Tutorial illustrate an example from Mysql Date Sort. To understand this example, we create a table 'employee1' with field name and data type. The create table statement is used to create a table employee1 .
Query to create table:-
| CREATE TABLE employee1( Empid int(10),Empname varchar(60),date date ); |
Output:-
 |
Query to insert data:-
The insert into add the records or rows value to the table.
| mysql> insert into
employee1(Empid,Empname,date)values('01','Girish','2008-12-20'); Query OK, 1 row affected (0.02 sec) mysql> insert into employee1(Empid,Empname,date)values('02','Komal','2008-12-21'); Query OK, 1 row affected (0.02 sec) mysql> insert into employee1(Empid,Empname,date)values('03','vineet','2008-12-21'); Query OK, 1 row affected (0.03 sec) mysql> insert into employee1(Empid,Empname,date)values('04','Amit','2008-12-20'); Query OK, 1 row affected (0.02 sec) |
Query to view data from the table created:-
mysql> select * from employee1; |
Output:-
+-------+---------+------------+ | Empid | Empname | date | +-------+---------+------------+ | 1 | Girish | 2008-12-20 | | 2 | Komal | 2008-12-21 | | 3 | vineet | 2008-12-21 | | 4 | Amit | 2008-12-20 | | 2 | Komal | 2008-12-23 | | 2 | Sandeep | 2008-12-24 | | 2 | suman | 2008-12-25 | +-------+---------+------------+ 7 rows in set (0.00 sec) |
Query to sort data from the table according to Empname created:-
The Query return you the sorted records in ascending order by date attribute.
mysql> select * from employee1 order by date asc; |
Output:-
+-------+---------+------------+ | Empid | Empname | date | +-------+---------+------------+ | 1 | Girish | 2008-12-20 | | 4 | Amit | 2008-12-20 | | 2 | Komal | 2008-12-21 | | 3 | vineet | 2008-12-21 | | 2 | Komal | 2008-12-23 | | 2 | Sandeep | 2008-12-24 | | 2 | suman | 2008-12-25 | +-------+---------+------------+ 7 rows in set (0.00 sec) |