mysql 除数为0错误

ERROR 1365 (22012): Division by zero

def safe_division(numerator, denominator):
    if denominator == 0:
        return None  # 或者抛出自定义异常
    return numerator / denominator

SELECT 
    CASE 
        WHEN denominator != 0 THEN numerator / denominator 
        ELSE NULL 
    END AS result
FROM your_table;

DELIMITER //

CREATE TRIGGER check_denominator_before_insert
BEFORE INSERT ON your_table
FOR EACH ROW
BEGIN
    IF NEW.denominator = 0 THEN
        SIGNAL SQLSTATE '45000'
        SET MESSAGE_TEXT = 'Denominator cannot be zero';
    END IF;
END//

CREATE TRIGGER check_denominator_before_update
BEFORE UPDATE ON your_table
FOR EACH ROW
BEGIN
    IF NEW.denominator = 0 THEN
        SIGNAL SQLSTATE '45000'
        SET MESSAGE_TEXT = 'Denominator cannot be zero';
    END IF;
END//

DELIMITER ;

DELIMITER //

CREATE PROCEDURE safe_division_proc(IN numerator INT, IN denominator INT, OUT result FLOAT)
BEGIN
    IF denominator = 0 THEN
        SET result = NULL;  -- 或者抛出自定义错误
    ELSE
        SET result = numerator / denominator;
    END IF;
END//

DELIMITER ;