How to change an existing column data type?

Question

One of the columns in a somewhat large table (~ 10,000 records) refers to the DECIMAL data type (10.0). I am using MySQL.

I would like the values ​​displayed in 2 decimal places, so I need to change this to DECIMAL (10,2) without twisting the table of existing entries. How can I do that?

Answer 1

What DBMS are you using? you can try this for MySQL:

alter table tblName modify columnName newDataType;