NYCPHP Meetup

NYPHP.org

[nycphp-talk] MySQL Syntax questions

Rolan Yang rolan at omnistep.com
Wed May 28 22:39:12 EDT 2008


Steve Manes wrote:
> Kristina Anderson wrote:
>> Tim, with regard to the second query, I wanted the entire row not 
>> just the ID...do I need to do two queries to get that?
>
> Or a subquery:
>
> SELECT
>    *
> FROM
>    table_foo
> WHERE
>    id = (SELECT MAX(id) FROM table_foo);
>
>

select * from table_foo order by id desc limit 1



More information about the talk mailing list