mysql将角度转为小数

decimal_degree = degree + (minute / 60) + (second / 3600)

CREATE TABLE angles (
    id INT AUTO_INCREMENT PRIMARY KEY,
    degree INT,
    minute INT,
    second INT
);

INSERT INTO angles (degree, minute, second) VALUES
(30, 30, 0),
(45, 0, 0),
(60, 15, 30);

SELECT 
    id,
    degree + (minute / 60.0) + (second / 3600.0) AS decimal_degree
FROM 
    angles;

ALTER TABLE angles ADD COLUMN decimal_degree DECIMAL(10, 8);

UPDATE angles SET decimal_degree = degree + (minute / 60.0) + (second / 3600.0);

DELIMITER //

CREATE TRIGGER validate_angles_before_insert
BEFORE INSERT ON angles
FOR EACH ROW
BEGIN
    IF NEW.minute >= 60 OR NEW.second >= 60 THEN
        SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Invalid angle format';
    END IF;
END //

DELIMITER ;