MySQL What field type can save decimals and integers

There is a field can be stored in integers and decimals, such as 43 and 43,000, can be saved, how should be set

Reply content:

There is a field can be stored in integers and decimals, such as 43 and 43,000, can be saved, how should be set

Different types of storage results:
decimal:43.00 4.30
varchar:43 4.3

Feel all you can, show on demand or consider storage format based on performance

Are you talking about 43 or 4.3 or 43 or 43,000 dollars? If it is the former, then it is best to use decimal, the number of digits is uncertain and the accuracy is not required double can also. Otherwise only string

