mysql sql语句decimal

DECIMAL(precision, scale)

-- 示例：插入超出范围的值
INSERT INTO table_name (decimal_column) VALUES (12345678901234567890.123456);

-- 错误信息：Out of range value for column 'decimal_column' at row 1

-- 解决方法：调整插入的值
INSERT INTO table_name (decimal_column) VALUES (1234567890.12);

-- 示例：插入超出精度的值
CREATE TABLE table_name (
    decimal_column DECIMAL(5, 2)
);

INSERT INTO table_name (decimal_column) VALUES (1234.567);

-- 错误信息：Data truncation: Out of range value for column 'decimal_column' at row 1

-- 解决方法：增加精度
ALTER TABLE table_name MODIFY decimal_column DECIMAL(10, 2);

-- 示例：使用整数类型存储货币值
CREATE TABLE table_name (
    currency_column BIGINT
);

INSERT INTO table_name (currency_column) VALUES (123456789);

-- 计算时转换为 DECIMAL 类型
SELECT CAST(currency_column AS DECIMAL(10, 2)) FROM table_name;