Wrong field type, changing entries from ".1" to "0.1" ?

[Mutley]

I set my field to the wrong type so entered loads of data like this:

 

0.1

0.2

0.3

 

etc

 

It changed it to

 

.1

.2

.3

 

How do I mass change my fields, so I don't have to re-enter it all? What field type do I need? INT?

[Mutley]

I had it on CHAR but only set length to 2, not 3! Oops.

[AndyB]

If they're numerical, why would you use CHAR as a field type instead of FLOAT?

[bubblegum.anarchy]

A simple solution:

 

ALTER TABLE table_name MODIFY column_name FLOAT NOT NULL DEFAULT 0;

 

All the values .1 .2 etc.. will become 0.1 0.2 etc...

 

EDIT: Just be aware that non numeric values will be converted to zero.