Re: mysql, finding the last record

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



For the last Auto-increment
        SELECT LAST_INSERT_ID() FROM tblName;

For the last row data:
        SELECT col1, col2, col3, col4 FROM tblName ORDER BY SortedColumn
LIMIT 1

I don't know what you are looking for exactly.
Explain and we will try to help though I am not an expert.


Thanks
Emery
----- Original Message -----
From: "Joe Nilson Zegarra Galvez" <nzegarra@kolareal.net>
To: <php-db@lists.php.net>
Sent: Friday, September 26, 2003 19:38
Subject: Re:  mysql, finding the last record


> if you are seeking for the last in autoincrement field, in your select use
> this:
>
> select max(field) from table;
>
> if is other, well, i dont remember :D
>
> Regards
>
> Nilson
>
> John Ryan dijo:
> > is there any quick way of selecting the 'last' row in a mysql table?? i
> > could write some messy code but id prefer an elegant solution.
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
>
>
> -------------------------
> Joe Nilson Zegarra Galvez
>    Sistemas Kola Real
>  Telefax : 0051-54-256658
>   Movil: 0051-54-9603244
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux