Data type: Difference between revisions

Jump to navigation Jump to search
155 bytes added ,  25 May 2015
Line 60: Line 60:


=== 價錢/金額 ===
=== 價錢/金額 ===
* DECIMAL(10,2)<ref> [http://stackoverflow.com/questions/628637/best-data-type-for-currency sql - Best Data Type for Currency - Stack Overflow]{{access | date=2012-03-07}} </ref>
* DECIMAL(10,2)<ref> [http://stackoverflow.com/questions/628637/best-data-type-for-currency sql - Best Data Type for Currency - Stack Overflow]{{access | date=2012-03-07}} </ref><ref>[http://zhidao.baidu.com/question/682060470049185972.html mysql 用什么数据类型表示价格?_百度知道]{{access | date=2015-05-25}}  </ref>
* ex:  
* ex:  
* range/limit: 0.00 ~ 99999999.99
* range/limit: 0.00 ~ 99999999.99

Navigation menu