RE: Getting most recent row from Database

From: Gentry, Michael \(Contractor\) ("Gentry,)
Date: Wed Jul 20 2005 - 08:49:50 EDT

  • Next message: Kevin Menard: "Java 5 Class Generation Templates"

    That would be cool. I've not kept up with MySQL much. I have 4.0.12
    installed locally and I know subselects don't work on it. Don't get me
    wrong, I'm not MySQL bashing, but it lacks features others have (and has
    features others lack).

    Thanks,

    /dev/mrg

    -----Original Message-----
    From: Kevin Menard [mailto:kmenar..ervprise.com]
    Sent: Tuesday, July 19, 2005 7:27 PM
    To: cayenne-use..bjectstyle.org
    Subject: Re: Getting most recent row from Database

    On Monday 18 July 2005 16:26, Gentry, Michael (Contractor) wrote:

    > That assumes your date column contains valid data (most recently
    > inserted row has the most recent date) and that you aren't using MySQL
    > or any other DB server which doesn't support nested selects.

    I think MySQL 4.1 finally added these. 

    -- 
Kevin

    This archive was generated by hypermail 2.0.0 : Wed Jul 20 2005 - 08:49:56 EDT