A mysql routine to insert value within a table and retrieve the pk (with autoincrement)

function.mysql

drop function if exists create_server;
delimiter $$


CREATE FUNCTION create_server(server_name varchar(50), user_id int)
    RETURNS int
DETERMINISTIC
BEGIN
    INSERT INTO server(name, owner_id) VALUES (server_name, user_id);
    return last_insert_id();
END $$
delimiter ;