You must use fixed-point numeric data type for storing the money values in MYSQL like this:
Here, 15 is the precision (i.e. total length of value including decimal places) and 2 is the number of digits after the decimal point.
Note: As money needs an exact representation. So, never use data-type that is only approximate like float.
For more information, you can refer to MySQL Numeric Types
You can learn in-depth about SQL statements, queries and become proficient in SQL queries by enrolling in our industry-recognized SQL training.