What would be equivalent of Number(4) of Oracle database to MySQL Datatype ?
将Oracle数据库的数字(4)等价于MySQL数据类型?
1 个解决方案
#1
3
In Oracle:
在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.
数字数据类型存储固定和浮点数。几乎任何大小的数字都可以存储，并保证可在不同的操作系统之间移植，精度最高可达38位。
7,456,123.89 as NUMBER(9) is stored as 7456124.
7 456,123.89作为数字(9)存储为7456124。
甲骨文原生数据类型
In MySQL:
在MySQL中:
You could use any of the following datatypes since you don't want to store the decimal part of the value...
您可以使用以下任何数据类型，因为您不想存储值的小数部分……
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数据类型
#1
3
In Oracle:
在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.
数字数据类型存储固定和浮点数。几乎任何大小的数字都可以存储，并保证可在不同的操作系统之间移植，精度最高可达38位。
7,456,123.89 as NUMBER(9) is stored as 7456124.
7 456,123.89作为数字(9)存储为7456124。
甲骨文原生数据类型
In MySQL:
在MySQL中:
You could use any of the following datatypes since you don't want to store the decimal part of the value...
您可以使用以下任何数据类型，因为您不想存储值的小数部分……
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数据类型