[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
Automatic Email Organization without missing anything!