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
On Fri, 31 Aug 2001, Sinisa Milivojevic wrote:
> =?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"
> >
=?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 column 'nan' in 'field list'
=?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'
12 matches
Mail list logo
