dream_life5200 2015-04-10 15:30
浏览 253
已采纳

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

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.

  • 写回答

2条回答 默认 最新

  • dongpi3237 2015-04-10 15:59
    关注

    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.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题？

悬赏问题

  • ¥15 微信会员卡等级和折扣规则
  • ¥15 微信公众平台自制会员卡可以通过收款码收款码收款进行自动积分吗
  • ¥15 随身WiFi网络灯亮但是没有网络，如何解决？
  • ¥15 gdf格式的脑电数据如何处理matlab
  • ¥20 重新写的代码替换了之后运行hbuliderx就这样了
  • ¥100 监控抖音用户作品更新可以微信公众号提醒
  • ¥15 UE5 如何可以不渲染HDRIBackdrop背景
  • ¥70 2048小游戏毕设项目
  • ¥20 mysql架构，按照姓名分表
  • ¥15 MATLAB实现区间[a,b]上的Gauss-Legendre积分