modify int to float (mysql)

Question

I'm trying to change datatype from INT to FLOAT in MySQL like this:

ALTER TABLE user MODIFY rate float(5) NOT NULL

But current data is droped. Is there any way to convent\save data from INT to FLOAT with SQL?

Answer 1

I have just tried

ALTER TABLE user MODIFY rate float(5) NOT NULL

with mysql 5.6.26 and it worked without dropping the value.