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 verify this by doing a select on the above table.
'nan' is a special float value which stands for 'not a number'. You
should not be able to store this into a float column in MySQL.
Regards,
Monty
---------------------------------------------------------------------
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
