2017.04.26 / 22:04
[mysql] ¼Ò¼öÁ¡ ÀÌÇÏ Æ¯Á¤ ÀÚ¸®¼ö±îÁö 0À¸·Î ä¿ì±â (right 0 padding in mysql float)
tomcater
Ãßõ ¼ö 320
¼Ò¼öÁ¡ ÀÌÇÏ 2ÀÚ¸®ÀÇ °ªÀ» Mysql¿¡ ÀúÀåÇÒ ¶§, ¸¶Áö¸· ¼ýÀÚ°¡ 0À̸é, ±× °ªÀº mysql¿¡¼ Áö¿î´Ù.
1010.10 À̶ó´Â °ªÀ» ÀúÀåÇϸé 1010.1 ¸¸ ¾ò¾î¿Ã ¼ö ÀÖ´Ù.
¾ð¾î¸¦ ÅëÇؼ NumberformatÀ» ¸ÂÃâ ¼ö ÀÖÁö¸¸, °£´ÜÈ÷ mysql select ¿¡¼µµ FORMATÀ» ÀÌ¿ëÇؼ ä¿ï ¼ö ÀÖ´Ù.
http://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_format
¿¹¸¦ µé¾î SELECT FORMAT(1010.1, 2) ÀÇ °á°ú´Â 1010.12 ÀÌ´Ù.
¸¸¾à as¸¦ »ç¿ëÇÏ°í ÀÖ´Ù¸é ´ÙÀ½Ã³·³ ¾µ ¼ö ÀÖ´Ù.
FORMAT(sum(avg_duration),2) as sumOfDuration
Ãâó: http://knight76.tistory.com/entry/mysql-¼Ò¼öÁ¡-ÀÌÇÏ-ƯÁ¤-ÀÚ¸®¼ö±îÁö-0À¸·Î-ä¿ì±â-right-0-padding-in-mysql-float [±è¿ëȯ ºí·Î±×(2004-2017)]