请问能否在mysql中可否创建double型的字段呢?
解决方案 »
- 问题求解:在MYSQL中,对表的一列数字进行分组循环累加
- 一个mysql存储过程中用replace出现的问题,请高手指教
- 祝大家新年愉快 请教一条mysql查询替换语句
- MySQL自定义函数中要删除表怎么处理?
- 在MYSQL中检索某个时间后的所有记录用什么命令
- mysql group by?
- 字段长度不够会引起乱码吗?
- 关于auto increase属性的字段
- 会员制,计算积分
- 请问在mysql中怎么建立自动增加的字段呢 , 好想在mysql中没有那么强大的工具。
- mysql5.5 半同步参数rpl_semi_sync_master_timeout 测试
- 请问使用 sqlite3 如何对日期进行排序?
DOUBLE[(M,D)] [UNSIGNED] [ZEROFILL] A normal-size (double-precision) floating-point number. Allowable values are -1.7976931348623157E+308 to -2.2250738585072014E-308, 0, and 2.2250738585072014E-308 to 1.7976931348623157E+308. These are the theoretical limits, based on the IEEE standard. The actual range might be slightly smaller depending on your hardware or operating system. M is the total number of digits and D is the number of digits following the decimal point. If M and D are omitted, values are stored to the limits allowed by the hardware. A double-precision floating-point number is accurate to approximately 15 decimal places. UNSIGNED, if specified, disallows negative values. DOUBLE PRECISION[(M,D)] [UNSIGNED] [ZEROFILL], REAL[(M,D)] [UNSIGNED] [ZEROFILL] These types are synonyms for DOUBLE. Exception: If the REAL_AS_FLOAT SQL mode is enabled, REAL is a synonym for FLOAT rather than DOUBLE.