MySQL View Decimal Place

Question

I have a MySQL view called Balance created from 2 order and income tables using PHPMyAdmin and containing some calculated ex fields: CustomerBalance decimal place automatically becomes 8, I mean the Decimal type field decimal(50,8)
How can I do only 2?

Answer 1

You can use truncate

  SELECT TRUNCATE(1.999,2); 

return 1.99

  select TRUNCATE(your_column,2) from your_table; 

Answer 2

In the select list, where you evaluate the CustomerBalance expression, explicitly truncate or round (depending on your requirements) the result to two digits:

 select ... round(..., 2) as CustomerBalance ...