mysql 插入数据并返回

-- 插入数据
INSERT INTO users (name, email) VALUES ('John Doe', 'john@example.com');

-- 获取刚刚插入的数据ID
SELECT LAST_INSERT_ID();

-- 插入数据并返回
INSERT INTO users (name, email) VALUES ('John Doe', 'john@example.com')
RETURNING id;

DELIMITER //

CREATE PROCEDURE InsertUser(IN name VARCHAR(255), IN email VARCHAR(255), OUT user_id INT)
BEGIN
    INSERT INTO users (name, email) VALUES (name, email);
    SET user_id = LAST_INSERT_ID();
END //

DELIMITER ;

-- 调用存储过程
CALL InsertUser('John Doe', 'john@example.com', @user_id);
SELECT @user_id;

START TRANSACTION;

INSERT INTO users (name, email) VALUES ('John Doe', 'john@example.com')
RETURNING id INTO @user_id;

COMMIT;

SELECT @user_id;