Type description of 'money' in mysql
- 2020-05-06 11:48:06
- OfStack
The instructions are as follows:
money holds the currency value data type, which ranges from -922337203685477.5808 to +922337203685477.5808 has a maximum length of 8 bytes.
smallmoney holds the currency value data type, ranging from -214748.3647 to +214748.3647 with a maximum length of 4 bytes.
As you can see, you can consider using the double type, because double has 8 bytes, while float has 4 bytes,