📄 type_newdecimal-big.result
字号:
drop procedure if exists sp1;CREATE PROCEDURE sp1()BEGIN DECLARE v1, v2, v3, v4 DECIMAL(28,12);DECLARE v3_2, v4_2 DECIMAL(28, 12);DECLARE counter INT;SET v1 = 1;SET v2 = 2;SET v3 = 1000000000000;SET v4 = 2000000000000;SET counter = 0;WHILE counter < 100000 DOSET v1 = v1 + 0.000000000001;SET v2 = v2 - 0.000000000001;SET v3 = v3 + 1;SET v4 = v4 - 1;SET counter = counter + 1; END WHILE;SET v3_2 = v3 * 0.000000000001;SET v4_2 = v4 * 0.000000000001;SELECT v1, v2, v3, v3_2, v4, v4_2;END//call sp1()//v1 v2 v3 v3_2 v4 v4_21.000000100000 1.999999900000 1000000100000.000000000000 1.000000100000 1999999900000.000000000000 1.999999900000drop procedure sp1;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -