티스토리 뷰

공부

[MySQL] Decimal(M, D)

승가비 2020. 4. 9. 23:28
728x90

M is the maximum number of digits

(the precision). It has a range of 1 to 65. (Older versions of MySQL allowed a range of 1 to 254.)

 

D is the number of digits to the right of the decimal point (the scale).

It has a range of 0 to 30 and must be no larger than M.

 

https://stackoverflow.com/questions/1818046/what-does-m-d-mean-in-decimalm-d-exactly

 

What does M,D mean in decimal(M,D) exactly?

Does anyone know about this?

stackoverflow.com

http://tcpschool.com/mysql/mysql_datatype_numeric

 

코딩교육 티씨피스쿨

4차산업혁명, 코딩교육, 소프트웨어교육, 코딩기초, SW코딩, 기초코딩부터 자바 파이썬 등

tcpschool.com

 

728x90

'공부' 카테고리의 다른 글

[Python] math ceil & floor & trunc & round  (0) 2020.04.09
[Python] replace string  (0) 2020.04.09
[Python] Dictionary  (0) 2020.04.09
[MySQL] install  (0) 2020.04.09
[LINE-Bot] Notify  (0) 2020.04.06
댓글