我在为MySQL编写SQL查询时遇到了一些问题。我有一个具有以下结构的表:mysql>selectid,pass,valfromdata_r1limit10;+------------+--------------+----------------+|id|pass|val|+------------+--------------+----------------+|DA02959106|5.0000000000|44.4007000000||08A5969201|1.0000000000|182.4100000000||08A5969201|2.0000000000|138.7880

我在为MySQL编写SQL查询时遇到了一些问题。我有一个具有以下结构的表:mysql>selectid,pass,valfromdata_r1limit10;+------------+--------------+----------------+|id|pass|val|+------------+--------------+----------------+|DA02959106|5.0000000000|44.4007000000||08A5969201|1.0000000000|182.4100000000||08A5969201|2.0000000000|138.7880

格式化要打印的数字时，12位数字的格式是在点后紧跟冒号。为什么会这样？这是AIX系统上的Python2.7。$uname-a;/opt/bin/python2.7AIXmyserver1600F6A5CC4C00Python2.7.12(default,Sep292016,12:02:17)[C]onaix5Type"help","copyright","credits"or"license"formoreinformation.>>>'{0:.10f}'.format(123456789012)'123456789011.:000000000'>>>fromdecimalimport

格式化要打印的数字时，12位数字的格式是在点后紧跟冒号。为什么会这样？这是AIX系统上的Python2.7。$uname-a;/opt/bin/python2.7AIXmyserver1600F6A5CC4C00Python2.7.12(default,Sep292016,12:02:17)[C]onaix5Type"help","copyright","credits"or"license"formoreinformation.>>>'{0:.10f}'.format(123456789012)'123456789011.:000000000'>>>fromdecimalimport