用于在sql php中存储折扣的数据类型[关闭]

Question

I need to create a table for product management in that table field include like price , image , discount so any one can help me that which datatype is used for all of them.

Answer 1

It isn't a simple question as it seems at first look. I suggest you to read first how floats is implemented in different databases and programming languages. It will help you understand why you never shoud use floats to sotre money.

This article Always use decimal for money may help you.