shantanu oak <[EMAIL PROTECTED]> wrote on 07/18/2005 01:17:57 PM:
> I am getting two different results for the same set of commands on two
> different versions of MySQL.
> Can anyone explain what the issue is?
>
> CREATE TABLE `testdecimal` (
> `rate` decimal(7,4) NOT NULL default '0.'
> ) EN
Is because 7 is the size of the record, and 4 is the size of the "decimals"
so:
Decimal(7,4) can allocate only 999.
If you want to allocate 1468 then you must declare as decimal(8,4) to 4
"decimals" and 4 "integers" in version 5 is the same as oracle
The first parameter is the total number
In the last episode (Jul 18), shantanu oak said:
> I am getting two different results for the same set of commands on
> two different versions of MySQL. Can anyone explain what the issue
> is?
>
> CREATE TABLE `testdecimal` (
> `rate` decimal(7,4) NOT NULL default '0.'
> ) ENGINE=MyISAM;
>
>
