decimal(6,2) On 5/18/05, Philippe Poelvoorde <[EMAIL PROTECTED]> wrote: > Jerry Swanson wrote: > > > I need to change format from varchar(10) to decimal. > > When I alter the table the data is trimmed. > > > > What I'm doing wrrong? > > > > TH > > > > ALTER TABLE your_table MODIFY your_column double NOT NULL DEFAULT '0.0'; > should normally work. What is the command you are doing and have you > example results ? > How did you declare your decimal column ? > > -- > Philippe Poelvoorde > COS Trading Ltd. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
