Page is a not externally linkable
- Code, Content, and Presentation
-- Databases
---- Mysql - Converting varchar field to tinyint


rocknbil - 4:01 pm on May 16, 2011 (gmt 0)


You probably want decimal so you don't lose your fractionals. Decimal is a lot easier to manage than float.

alter table yourtable change rating rating decimal(12,2) not null default '0.00';

That should order them properly, unless I'm missing something.


Thread source:: http://www.webmasterworld.com/databases_sql_mysql/4312723.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com