Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Sql Mysql-example Mysql Last Row

Related Tutorials


 
 

Share on Google+Share on Google+

Mysql Last Row

Advertisement
The Tutorial illustrate an example from 'Mysql Last Row'. To understand and grasp example we create a table employee1 with required fieldnames and datetypes respectively.

Mysql Last Row

     

Mysql Last Row is used to return the last records from table.

Understand with Example

The Tutorial illustrate an example from 'Mysql Last Row'. To understand and grasp example we create a table employee1 with required fieldnames and datetypes respectively.

 

 

 

Query to Create Table named employee1:

mysql>CREATE TABLE employee1 (              
         ->    Empid int(10),         
         ->    Empname varchar(60),   
         ->    date date 
         ->  );

Query to insert data into Table named employee1:

The Query insert into is used to add the records or rows to the table 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:

To view the records detail of table 'employee1' we use select query as given below:

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 row of Table named employee1:

The Query sorts the records from table employee1 and return the last records from table.

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

If you enjoyed this post then why not add us on Google+? Add us to your Circles



Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: January 17, 2009

Related Tutorials

Discuss: Mysql Last Row   View All Comments

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:2
ajit
February 18, 2012
good

good
Arun Kumar G
June 24, 2012
nice work :-)

its really helpful for me... its easy to understand too..
DMCA.com