 | | | why didn 't I insert small number into table? | why didn 't I insert small number into table? 2006-06-29 - By Dan Buettner
Back
Xiabo, can you post the output of SHOW CREATE TABLE <table> please?
See http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html
which indicates it could be due to how the column was created:
DOUBLE[(M,D)] [UNSIGNED] [ZEROFILL]
A normal-size (double-precision) floating-point number. Allowable
values are -1.7976931348623157E+308 to -2.2250738585072014E-308, 0,
and 2.2250738585072014E-308 to 1.7976931348623157E+308. These are the
theoretical limits, based on the IEEE standard. The actual range might
be slightly smaller depending on your hardware or operating system.
M is the total number of decimal digits and D is the number of digits
following the decimal point. If M and D are omitted, values are stored
to the limits allowed by the hardware. A double-precision
floating-point number is accurate to approximately 15 decimal places.
UNSIGNED, if specified, disallows negative values.
Dan
On 6/29/06, Xiaobo Chen <xiaobo@(protected)> wrote:
> Hi, all
>
> I have a table like this:
>
> +-- ---- --+-- ------+-- ---+-- --+-- ------+-- ----+
> | Field | Type | Null | Key | Default | Extra |
> +-- ---- --+-- ------+-- ---+-- --+-- ------+-- ----+
> | id_freq | int(11) | | PRI | 0 | |
> | id_theta | int(11) | | PRI | 0 | |
> | es | double | | | 0 | |
> +-- ---- --+-- ------+-- ---+-- --+-- ------+-- ----+
>
> the values for 'es' is very small, like 10^-8. When I checked the result
> after running my code, the column for 'es' are still '0's.
>
> Could anybody give a hint why this occured and how to avoid this?
>
> Thanks in advance.
>
> Xiaobo
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=drbuettner@(protected)
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql@(protected)
|
|
|