amsey, Robert L
Cc: mysql@lists.mysql.com
Subject: Re: odd problem with select as statement
i.e. just try this:
mysql> select 4E5664736F400E8B482EA7AA67853D13;
ERROR 1367 (22007): Illegal double '4E5664736' value found during parsing
-Hank
On Mon, Dec 20, 2010 at 12:50 PM, Hank
mailto:
i.e. just try this:
mysql> select 4E5664736F400E8B482EA7AA67853D13;
ERROR 1367 (22007): Illegal double '4E5664736' value found during parsing
-Hank
On Mon, Dec 20, 2010 at 12:50 PM, Hank wrote:
>
> Here's my 5 second guess..
>
> 4E5664736... is being interpreted as a number in scientific no
Here's my 5 second guess..
4E5664736... is being interpreted as a number in scientific notation ..
i.e. 4*10^5664736 and the parser doesn't like that as a field name.
-Hank
On Mon, Dec 20, 2010 at 12:43 PM, Ramsey, Robert L
wrote:
> I am having the hardest time getting a select as statement
I can't tell you 'why' it is occurring when the field name begins with 4E5,
but you can solve your problem by enclosing all your field names
in backticks ( ` ).
IE:
SELECT field AS `4E5664736F400E8B482EA7AA67853D13`
On Mon, Dec 20, 2010 at 11:43 AM, Ramsey, Robert L
wrote:
> I am having the h
I am having the hardest time getting a select as statement right. Here is the
full query:
select
SUM(IF(image='EE0840D00E2ED8A317E5FA9899C48C19',1,0)) as
EE0840D00E2ED8A317E5FA9899C48C19,
SUM(IF(image='235C7987796D5B7CEBF56FBDA2BF7815',1,0)) as
235C7987796D5B7CEBF56FBDA2BF7815,
SUM(IF(image='9
