MySQL 数据类型声明中 DECIMAL(x, y) 中 x 和 y 的边界值是多少？

发布于 2024-11-17 16:12:22 字数 498 浏览 1 评论 0原文

我有以下 UDF

drop function if exists getCurrency$$

create function getCurrency(dt datetime, x decimal(19,4), y decimal(19, 4)) 
returns decimal(10,4) reads sql data
begin
     declare currencyval decimal(10,4);

     /* Some conditions */
     select case when dt = "2000-12-31" then 0 else round((x/y), 4) into currencyval;

     return currencyval;
end$$

有时此 UDF 会引发数据截断错误。我可以解决这个问题，但在此之前我想要一些有关 Decimal 数据类型以及参数中 10、4 的含义的信息。

如果你能给出一些带有边界条件的例子就好了。

原文

I have got the following UDF

drop function if exists getCurrency$

create function getCurrency(dt datetime, x decimal(19,4), y decimal(19, 4)) 
returns decimal(10,4) reads sql data
begin
     declare currencyval decimal(10,4);

     /* Some conditions */
     select case when dt = "2000-12-31" then 0 else round((x/y), 4) into currencyval;

     return currencyval;
end$

Sometimes this UDF throws Data truncation error.
I can resolve the issue but the before even that I want some information regarding the Decimal data type and the significance of 10, 4 in the parameters.

It would be good if you give some examples with the boundary conditions.

分享到QQ

分享到微博