oracle中的number类型对应mysql,什么相当于Oracle数据库的Number(4)到MySQL数据类型?...
什么相当于Oracle数据库的Number(4)到MySQL数据类型?解决方法:在Oracle中:The NUMBER datatype stores fixed andfloating-point numbers. Numbers ofvirtually any magnitude can be storedand are guaranteed portable amongdifferent s
什么相当于Oracle数据库的Number(4)到MySQL数据类型?
解决方法:
在Oracle中:
The NUMBER datatype stores fixed and
floating-point numbers. Numbers of
virtually any magnitude can be stored
and are guaranteed portable among
different systems operating Oracle, up
to 38 digits of precision.
数字(9)的7,456,123.89存储为7456124.
在MySQL中:
您可以使用以下任何数据类型,因为您不想存储值的小数部分…
SMALLINT( ) -32768 to 32767 normal 0 to 65535 UNSIGNED.
MEDIUMINT( ) -8388608 to 8388607 normal 0 to 16777215 UNSIGNED.
INT( ) -2147483648 to 2147483647 normal 0 to 4294967295 UNSIGNED.
BIGINT( ) -9223372036854775808 to 9223372036854775807 normal 0 to 18446744073709551615 UNSIGNED.
标签:mysql,types,numbers,oracle
来源: https://codeday.me/bug/20190627/1300467.html
更多推荐
所有评论(0)