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 | Type
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 database as follows
desc Spot
- ;
Maybe a long shot, but creating this table should have required using
backticks around `Column` because it's a reserved word. Made me wonder
if the ID field in the create statement was in backticks as well and
maybe has an extra character.
What does show create table Spot show?
Hi,
I have a
Hi,
Following is the output of show create table Spot
command
| Table | Create Table
.
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 Table
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:
mysqldump -f
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:
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-insert
--quick
Hi!
mmokrejs == mmokrejs iso-8859-2 writes:
cut
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
=?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 column 'nan' in 'field list'
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.
cut
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
=?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.
cut
I'm pretty sure the problem is with text nan being in place of a float
number.
--
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 help.
=?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
...
15 matches
Mail list logo