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)
|