mysql怎么使用自增uuid

CREATE TABLE users (
    id CHAR(36) NOT NULL DEFAULT (UUID()),
    name VARCHAR(255) NOT NULL,
    email VARCHAR(255) NOT NULL,
    PRIMARY KEY (id)
);

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

DELIMITER //

CREATE FUNCTION generate_ordered_uuid()
RETURNS CHAR(36)
DETERMINISTIC
BEGIN
    DECLARE uuid CHAR(36);
    SET uuid = CONCAT(
        LPAD(HEX(FLOOR(RAND() * POW(2, 128))), 32, '0'),
        LPAD(HEX(FLOOR(RAND() * POW(2, 128))), 32, '0'),
        LPAD(HEX(FLOOR(RAND() * POW(2, 128))), 32, '0'),
        LPAD(HEX(FLOOR(RAND() * POW(2, 128))), 32, '0'),
        LPAD(HEX(FLOOR(RAND() * POW(2, 128))), 32, '0')
    );
    RETURN uuid;
END //

DELIMITER ;

CREATE TABLE users (
    id CHAR(36) NOT NULL DEFAULT (generate_ordered_uuid()),
    name VARCHAR(255) NOT NULL,
    email VARCHAR(255) NOT NULL,
    PRIMARY KEY (id)
);