oracle中的number类型对应mysql,什么相当于Oracle数据库的Number(4)到MySQL数据类型？...

什么相当于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