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]