pgsql里的函数迁移mysql

-- PostgreSQL
CREATE FUNCTION add_numbers(a INT, b INT) RETURNS INT AS $$
BEGIN
    RETURN a + b;
END;
$$ LANGUAGE plpgsql;

-- MySQL
DELIMITER //
CREATE FUNCTION add_numbers(a INT, b INT) RETURNS INT
BEGIN
    RETURN a + b;
END //
DELIMITER ;

-- PostgreSQL
CREATE TABLE users (
    id SERIAL PRIMARY KEY,
    name VARCHAR(100),
    age INT
);

-- MySQL
CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100),
    age INT
);

-- PostgreSQL
CREATE OR REPLACE FUNCTION update_user_age() RETURNS TRIGGER AS $$
BEGIN
    NEW.age = OLD.age + 1;
    RETURN NEW;
END;
$$ LANGUAGE plpgsql;

CREATE TRIGGER update_age_trigger
BEFORE UPDATE ON users
FOR EACH ROW
EXECUTE FUNCTION update_user_age();

-- MySQL
DELIMITER //
CREATE TRIGGER update_age_trigger
BEFORE UPDATE ON users
FOR EACH ROW
BEGIN
    SET NEW.age = OLD.age + 1;
END //
DELIMITER ;