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 got back from vacation today and I didn't see that anyone else has
responded yet so I figure that later is better than never ;-)
Your INSERT speed will be directly related to how fast all of your JOINS
can be accomplished. Your JOIN speed is related to two things: the size of
your tables a
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 understand why.
I had the same problem last night,
eventually grant all to root on *.* identified by 'yourpass' got me in
I must have mucked up the permissions at
(the problem was with mysqlgui not mysqlshow though)
Sean
-Original Message-
From: Peter Matulis [mailto:[EMAIL PROTECTED]]
Sent: Tuesday,
You must have an rpm installation of mysql and your source installation.
Check to see if there are mysql* commands within /usr/bin directory. It's
going to search there first, then /usr/local/bin. The commands within
/usr/bin are going to look for the mysql-everthing within /var/lib/
Jonathan
---
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