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 --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 is at http://www.natur.cuni.cz/~mmokrejs
> >> MIPS / Institute for Bioinformatics <http://mips.gsf.de>
> >> GSF - National Research Center for Environment and Health
> >> Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany
> >>
> >>
>
> Sinisa> Yes, I saw this. Still, we should fix it.
>
> MySQL should never allow you to insert 'nan' into a column.
>
> It would be nice to know how this value was inserted in the first
> place.
Hmm, I did not write this code and can't find it quickly, but hust trying
to repeat it works:
mysql> show columns from rep;
+------------------+-----------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------+-----------------------+------+-----+---------+-------+
| id | mediumint(8) unsigned | | PRI | 0 | |
| prot_data_id | mediumint(8) unsigned | | MUL | 0 | |
| contig_data_id | mediumint(8) unsigned | | MUL | 0 | |
| contig_data_code | varchar(100) | | | | |
| code | varchar(100) | | MUL | | |
| length | int(11) | | | 0 | |
| mw | float(10,2) | | | 0.00 | |
| pI | float(10,2) | | | 0.00 | |
| class | varchar(255) | | MUL | | |
| mem | int(11) | | | 0 | |
| low | float(10,2) | | | 0.00 | |
| nonglob | float(10,2) | | | 0.00 | |
| coil | float(10,2) | | | 0.00 | |
| sigp | int(11) | | | 0 | |
| loc | varchar(255) | | MUL | | |
| summary | text | YES | | NULL | |
| geneid | varchar(255) | | MUL | | |
| classification | varchar(255) | | MUL | | |
| pubmed | varchar(255) | | MUL | | |
| comments | text | YES | | NULL | |
| remarks | text | YES | | NULL | |
| descr | varchar(255) | | MUL | | |
| manual | enum('yes','no') | YES | | NULL | |
+------------------+-----------------------+------+-----+---------+-------+
mysql> update rep set low='nan' where id=148;
Query OK, 1 row affected (0.07 sec)
Rows matched: 1 Changed: 1 Warnings: 1
'mysqladmin version' gives:
mysqladmin Ver 8.21 Distrib 3.23.41, for pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.41-log
Maybe we should check in application for the warning?
How can I see the warning? -Not on terminal, not in server logfile ...
--
Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
MIPS / Institute for Bioinformatics <http://mips.gsf.de>
GSF - National Research Center for Environment and Health
Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php