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.0000'
) ENGINE=MyISAM; 

INSERT INTO testdecimal SET rate=1468;

select * from testdecimal;
_____

version 4.1.12
1468.0000

version 5.0
999.9999

Shantanu Oak

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to