ISAM;
>
>
> This first query works (MySQL 4.0.25):
>
> SELECT l.id, MAX(l.id) AS maxid, l.host_address
> FROM `license` l
> WHERE l.is_visible='1'
> GROUP BY l.host_address
> ORDER BY maxid DESC
>
> but this second query fails with the error: #105
isible='1'
GROUP BY l.host_address
ORDER BY maxid DESC
but this second query fails with the error: #1054 - Unknown column 'maxid'
in 'on clause'
SELECT l.id, MAX(l.id) AS maxid, l.host_address, l2.firstname, l2.lastname
FROM `license` l
INNER JOIN license l2 ON l2.
UP BY l.host_address
ORDER BY maxid DESC
but this second query fails with the error: #1054 - Unknown column 'maxid'
in 'on clause'
SELECT l.id, MAX(l.id) AS maxid, l.host_address, l2.firstname, l2.lastname
FROM `license` l
INNER JOIN license l2 ON l2.id=maxid
WHERE l.is_visible
report as a bug for previous mysql versions but not for
> 5.0.15
>
> ERROR 1054 (42S22): Unknown column 'c.len' in 'on clause'
>
> the query that generated this works fine of mysql 5.0.11
>
> others having this issue? using OS X 10.4 (32bit)
>
> thank
hcir <[EMAIL PROTECTED]> wrote on 10/31/2005 12:37:15 PM:
> iH
>
> i saw this report as a bug for previous mysql versions but not for
> 5.0.15
>
> ERROR 1054 (42S22): Unknown column 'c.len' in 'on clause'
>
> the query that generated this
iH
i saw this report as a bug for previous mysql versions but not for
5.0.15
ERROR 1054 (42S22): Unknown column 'c.len' in 'on clause'
the query that generated this works fine of mysql 5.0.11
others having this issue? using OS X 10.4 (32bit)
thanks
Rich Allen
Dare &am
chars.
John A. McCaskey
-Original Message-
From: kaustubh shinde [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 26, 2004 1:11 PM
To: Michael Kruckenberg
Cc: [EMAIL PROTECTED]
Subject: Re: Error 1054
Hi,
Following is the output of show create table Spot
command
| Table | Create
| varchar(32) | YES | | NULL
> |
> > |
> > | Column| varchar(32) | YES | | NULL
> |
> > |
> > | Probe_ID | int(11) | | | 0
> |
> > |
> > | Array_Type_ID | int(11) | | | 0
&g
y_Type_ID | int(11) | | | 0 |
|
+---+-+--+-+-+---+
When I try to access the field ID shown above though,
it gives me error:
mysql> select ID from Spot;
ERROR 1054: Unknown column 'ID' in 'field list'
This is kind of weird.
backticks didnt work :(
--- Victor Pendleton <[EMAIL PROTECTED]> wrote:
> Try using backticks `ID`
>
> -Original Message-
> From: kaustubh shinde
> To: [EMAIL PROTECTED]
> Sent: 5/26/04 1:05 PM
> Subject: Error 1054
>
> Hi,
> I have a table Spot in the
Try using backticks `ID`
-Original Message-
From: kaustubh shinde
To: [EMAIL PROTECTED]
Sent: 5/26/04 1:05 PM
Subject: Error 1054
Hi,
I have a table Spot in the database as follows
desc Spot
-> ;
+---+-+--+-+-+---+
| Field | T
int(11) | | | 0 |
|
+---+-+--+-+-+---+
When I try to access the field ID shown above though,
it gives me error:
mysql> select ID from Spot;
ERROR 1054: Unknown column 'ID' in 'field list'
This is ki
Hi!
> "mmokrejs" == mmokrejs writes:
mysql> update rep set low='nan' where id=148;
mmokrejs> Query OK, 1 row affected (0.07 sec)
mmokrejs> Rows matched: 1 Changed: 1 Warnings: 1
The above will just set '0' in the 'low' column.
(The string 'nan' converted to a number is 0)
You can ver
Hi!
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> =?iso-8859-2?Q?Martin_MOKREJ=A9?= writes:
>> And should say that
>>
>> update rep set low='0.00' where id=148;
>>
>> solved my problem for command:
>> mysqldump -f --socket=/tmp/mysql.sock --add-drop-table --extended
i can reproduce it on 3.23.32
create table test (id int(13),low float(10,2) )
insert into test values (1,1)
insert into test values (1,'nan')
id low
1 1.00
1 nan
doh..
-
Before posting, please check:
http://w
On Sun, 2 Sep 2001, Michael Widenius wrote:
Hi,
> > "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
>
> Sinisa> =?iso-8859-2?Q?Martin_MOKREJ=A9?= writes:
> >> And should say that
> >>
> >> update rep set low='0.00' where id=148;
> >>
> >> solved my problem for command:
> >> mys
ysql -f --host=pednew -C Cmuridarum"
> > ERROR 1054 at line 52: Unknown column 'nan' in 'field list'
> >
> > I have even tried "OPTIMIZE TABLE REP; REPAIR TABLE REP;", no luck.
> > "SHOW COLUMNS FROM REP;" does NOT show any column
=?iso-8859-2?Q?Martin_MOKREJ=A9?= writes:
> And should say that
>
> update rep set low='0.00' where id=148;
>
> solved my problem for command:
> mysqldump -f --socket=/tmp/mysql.sock --add-drop-table --extended-insert
> --quick --databases Cmuridarum rep | mysql -f --host=pednew -C Cmuridarum
>
On Fri, 31 Aug 2001, Sinisa Milivojevic wrote:
> May be you used some special chars in column names. In that case you
> should use instruct mysqldump to use backticks for table and column
> names.
Ehh, now I know what you meant: - to use -Q option to mysqldump , ok
but it anyway did not hel
=?iso-8859-2?Q?Martin_MOKREJ=A9?= writes:
> On Fri, 31 Aug 2001, Sinisa Milivojevic wrote:
>
> Ehh, now I know what you meant: - to use -Q option to mysqldump , ok
> but it anyway did not help.
>
> I'm pretty sure the problem is with text "nan" being in place of a float
> number.
>
> --
And should say that
update rep set low='0.00' where id=148;
solved my problem for command:
mysqldump -f --socket=/tmp/mysql.sock --add-drop-table --extended-insert
--quick --databases Cmuridarum rep | mysql -f --host=pednew -C Cmuridarum
... to be complete. ;)
--
Martin Mokrejs - PGP5.0i key i
=?iso-8859-2?Q?Martin_MOKREJ=A9?= writes:
> On Fri, 31 Aug 2001, Sinisa Milivojevic wrote:
>
> Ehh, now I know what you meant: - to use -Q option to mysqldump , ok
> but it anyway did not help.
>
> I'm pretty sure the problem is with text "nan" being in place of a float
> number.
>
> --
=?iso-8859-2?Q?Martin_MOKREJ=A9?= writes:
> Hi again,
> I have the following problem:
>
> "mysqldump -# --socket=/tmp/mysql.sock --add-drop-table -f --extended-insert
>--quick Cmuridarum rep | mysql -f --host=pednew -C Cmuridarum"
> ERROR 1054 at line 52: Unknown
=?iso-8859-2?Q?Martin_MOKREJ=A9?= writes:
> Hi again,
> I have the following problem:
>
> "mysqldump -# --socket=/tmp/mysql.sock --add-drop-table -f --extended-insert
>--quick Cmuridarum rep | mysql -f --host=pednew -C Cmuridarum"
> ERROR 1054 at line 52: Unknown
Hi again,
I have the following problem:
"mysqldump -# --socket=/tmp/mysql.sock --add-drop-table -f --extended-insert --quick
Cmuridarum rep | mysql -f --host=pednew -C Cmuridarum"
ERROR 1054 at line 52: Unknown column 'nan' in 'field list'
I have even tri
25 matches
Mail list logo
