Re: Problem with having

I Sent from my D - Reply message - From: "Rick James" To: "Larry Martell" , "shawn green" Cc: "mysql mailing list" Subject: Problem with having Date: Thu, Sep 26, 2013 12:11 PM Still more to this saga Comment 1: ... HAVING x; The expression ( x ) is evaluated as a true/false va

RE: Problem with having

Still more to this saga Comment 1: ... HAVING x; The expression ( x ) is evaluated as a true/false value, based on whether x is nonzero (true) or zero (false). Your 'x' is MIN(date_time) , which is very likely to be nonzero, hence TRUE. That is, the HAVING does nothing useful. Comment 2:

Re: Materialized Views

There is also www.materialized.info , providing a simpler example of creating a MV, including triggers to maintain it.