saraswathy saras wrote:
> Hi everybody,
>
> Can anybody help me?
I'll give it a shot.
> is there any other specific command instead order by ID DESC to select
> all the record from table where the ID is the last ID.The ID is
> autoincrement.
Try this:
select last_insert_id() as ID from TABLE limit 1;
Thanks,
Ozette
>
> Record is like this:-
>
> ID name gender
> 1 a F
> 2 b M
> 3 c M
> 4 d F
> 5 e M
>
> Result should be like this:-
>
> ID Name Gender
> 5 e M
>
> sql,query
>
> Thanks in advance
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> _________________________________________________________________
> Chat with friends online, try MSN Messenger: http://messenger.msn.com
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
--
_______________________________________
Email: [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php