Home Sql Sqldate Mysql Date Order

Mysql Date Order
Posted on: June 16, 2009 at 12:00 AM

Mysql Date Order is used to sort the records from a table in ascending order or descending order.

Mysql Date Order

Mysql Date Order is used to sort the records from a table in ascending order or descending order.

Understand with Example

The Tutorial illustrate an example from 'Date Order in Mysql'. To understand this example, we create a table employee1 with field attribute and data type. The create table 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 'employee1'.

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 for viewing the date field in ascending order using order by:-

The given below syntax return you the sorted records from a table employee1 on the basis of ascending order.

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.01 sec)

Query for viewing the date field in descending order using order by:-

The below Query return you the sorted records from a table by the descending order of field name date.

mysql> select * from employee1 order by date desc;

Output:-

+-------+---------+------------+
| Empid | Empname | date       |
+-------+---------+------------+
|     2 | suman   | 2008-12-25 |
|     2 | Sandeep | 2008-12-24 |
|     2 | Komal   | 2008-12-23 |
|     2 | Komal   | 2008-12-21 |
|     3 | vineet  | 2008-12-21 |
|     1 | Girish  | 2008-12-20 |
|     4 | Amit    | 2008-12-20 |
+-------+---------+------------+
7 rows in set (0.16 sec)

Related Tags for Mysql Date Order:
sql, mysql, c, table, date, data, type, order, tutorial, field, attribute, ria, this, create, tab, ie, example, with, to, exam, ld, e, il, it, pe, from, in, sta, m, tr, em, rate, tor, xa, xamp, s, ee, at, my, is, ll, mpl, ea, and, str, tt, tutor, s, s, ri, rd, th, st, ab, abl, ple, pl, nd, om, o

«Previous Index Next»