Mysql Last Record
Mysql Last Record is used to the return the record using order by
from table.
Understand with Example
To grasp this example we create a table 'employee1' using create
table with required fieldnames and datatypes required.
Query to Create Table named employee1:
mysql>CREATE TABLE employee1 (
-> Empid int(10),
-> Empname varchar(60),
-> date date
-> );
|
Query to insert records or rows in Table named employee1:
mysql>insert into employee1 values(01,'Girish','2008-12-20');
Query OK, 1 row affected (0.02 sec)
mysql>insert into employee1 values(02,'Komal','2008-12-21');
Query OK, 1 row affected (0.02 sec)
mysql>insert into employee1 values(03,'vineet','2008-12-21');
Query OK, 1 row affected (0.02 sec)
mysql>insert into employee1 values(04,'Amit','2008-12-20');
Query OK, 1 row affected (0.02 sec)
mysql>insert into employee1 values(02,'Komal','2008-12-23');
Query OK, 1 row affected (0.02 sec)
mysql>insert into employee1 values(02,'Sandeep','2008-12-24');
Query OK, 1 row affected (0.02 sec)
mysql>insert into employee1 values(02,'suman','2008-12-25');
Query OK, 1 row affected (0.02 sec)
mysql>insert into employee1 values(01,'AAA',' 2008-12-03');
Query OK, 1 row affected (0.02 sec)
|
Query to view data of Table named employee1:
The Query select is used to return the records from table
'employee1'.
mysql> select * from employee1;
+-------+---------+------------+
| Empid | Name | DOB |
+-------+---------+------------+
| 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 |
| 1 | AAA | 2008-12-03 |
+-------+---------+------------+
8 rows in set (0.00 sec)
|
Query to view last record of Table named employee1:
The order by sort the records on the basis of specified columns
and asc limit 1 return the first records from table employee1.
mysql> select * from employee1 order by empid,name,dob asc limit 1;
+-------+------+------------+
| Empid | Name | DOB |
+-------+------+------------+
| 1 | AAA | 2008-12-03 |
+-------+------+------------+
1 row in set (0.00 sec)
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
