How can I modify an existing column's data type?

mysql types sqldatatypes
oxo picture oxo · Nov 29, 2011 · Viewed 9.4k times · Source

One of the columns in a somewhat large table (~10,000 records) is of the data type DECIMAL(10,0). I'm using MySQL.

I'd like the values to be displayed to 2 decimal places, so I need to alter this to DECIMAL(10,2), without screwing up the table's existing records. How could this be done?

Answer

gprathour picture gprathour · Nov 29, 2011

Which DBMS are you using ? you can try like this for MySQL :

alter table tblName modify columnName newDataType;

Related questions

What is the difference between longblob and longtext in mysql?

What is difference between longblob and longtext in mysql? What should I use to save a long topic ?

Read More
What is the datatype to store boolean value in MySQL?

Possible Duplicate: Which MySQL Datatype to use for storing boolean values? I am a .NET programmer and using MySQL database for the first time in my life. I wanted to store boolean value, MySQL has BIT, but the .NET conversion …

Read More
Store CSS color values in DB

I need to store a CSS HEX color value (#FFFFFF for example) into a mysql database. Which type of data would I use and why it would be better over using another one?

Read More