RE: odd problem with select as statement

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:

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 wrote: > > Here's my 5 second guess.. > > 4E5664736... is being interpreted as a number in scientific no

Re: odd problem with select as statement

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

Re: odd problem with 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

odd problem with select as statement

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

Re: odd problem

| | Fax to: |

RE: odd problem

Your cardinality is null. Analyze the table and then do a show index. -Original Message- From: J S To: [EMAIL PROTECTED] Sent: 7/1/04 10:22 AM Subject: odd problem Hi, The code in my function below (insert_internet_usage) has suddenly dramatically slowed down and I don't understan

odd problem

Hi, The code in my function below (insert_internet_usage) has suddenly dramatically slowed down and I don't understand why. The logs I'm parsing are the same size as before, but what used to take 15 minutes has shot up to about 4 hours. It's almost as if the indexes had stopped working. I wonder

RE: Odd problem issueing commands at the console

t: Tuesday, June 26, 2001 5:03 PM To: Mysql (E-mail) Subject: Odd problem issueing commands at the console Just installed 3.23.37 on Red Hat 7.0 from source. I've done this a few times but this time I encountered a mysterious problem. a) server is started and runs under my

Re: Odd problem issueing commands at the console

athan - Original Message - From: "Peter Matulis" <[EMAIL PROTECTED]> To: "Mysql (E-mail)" <[EMAIL PROTECTED]> Sent: Tuesday, June 26, 2001 12:02 PM Subject: Odd problem issueing commands at the console > Just installed 3.23.37 on Red Hat 7.0 from source. I&

Re: Odd problem issueing commands at the console

Could it be that you have two mysql client binaries accessing two different config files - some remainders of a previous MySQL installation? Hannes On 6/26/01 9:02 AM, "Peter Matulis" <[EMAIL PROTECTED]> wrote: > Just installed 3.23.37 on Red Hat 7.0 from source. I've done this a few > times

Odd problem issueing commands at the console

Just installed 3.23.37 on Red Hat 7.0 from source. I've done this a few times but this time I encountered a mysterious problem. a) server is started and runs under my designated user (mysqladm:mysqlgrp) b) /usr/local/mysql/bin is in PATH of both root and mysqladm c) using either of these users,