How to change field type decimal?

Question

MySQL

Hello!
There is a table with a field whose type is decimal(8,2). Can you please tell me how to change it to type decimal(14,2)? Level of knowledge: none. The programmer sleeps off, but the problem needs to be solved :)

Answer 1

ALTER TABLE `tablename` CHANGE `fieldname` `fieldname` DECIMAL( 14, 2 ) NOT NULL