the new field - time - is a character field, length of 5,
and your order by will sort the data as such - so "00:..." is before "03:..."
The only reason why you don't have "00:.." times when you use a timestamp
between and ,
is because there are no times that start with "00:" in the criteria .. th
11 2:03 PM
To: Larry McGhaw
Cc: Daevid Vincent; mysql@lists.mysql.com
Subject: Re: WHERE does not work on calculated view field - Found word(s) list
error in the Text body
On 04/22/11 22:41, Larry McGhaw wrote:
> It does appear to be some type of bug to me.
Hm... do you have an idea how to wo
It does appear to be some type of bug to me.
Clearly from the select, the Typename field is not null, as shown here.
mysql> SELECT *, TypeName Is NULL, TypeName IS NOT NULL FROM `myview`;
++--+--+--+--+
| ID | Type | TypeName | TypeName Is NULL
First post was html version which got mangled, this text version should be
better.
CONNX MySQL Webinar
Learn about integrating all of your enterprise data into MySQL databases.
CONNX is easy to install and easy to use, yet sophisticated and powerful enough
to solve all of your enterprise wide
CONNX Webinar
Learn about integrating all of your enterprise data into MySQL databases.
CONNX is easy to install and easy to use, yet sophisticated and powerful enough
to solve all of your enterprise wide integration needs through a single product.
The CONNX platform integrates MySQL with more th