如何创建包含连接数组的表

CREATE TABLE Users (
    UserID INT PRIMARY KEY AUTO_INCREMENT,
    UserName VARCHAR(255) NOT NULL
);

CREATE TABLE Books (
    BookID INT PRIMARY KEY AUTO_INCREMENT,
    Title VARCHAR(255) NOT NULL
);

CREATE TABLE Authors (
    AuthorID INT PRIMARY KEY AUTO_INCREMENT,
    AuthorName VARCHAR(255) NOT NULL
);

CREATE TABLE BookAuthors (
    BookID INT,
    AuthorID INT,
    PRIMARY KEY (BookID, AuthorID),
    FOREIGN KEY (BookID) REFERENCES Books(BookID),
    FOREIGN KEY (AuthorID) REFERENCES Authors(AuthorID)
);

START TRANSACTION;

INSERT INTO Users (UserName) VALUES ('John Doe');
SET @userID = LAST_INSERT_ID();

INSERT INTO Books (Title) VALUES ('Introduction to Database Systems');
SET @bookID = LAST_INSERT_ID();

INSERT INTO Authors (AuthorName) VALUES ('Peter Rob');
SET @authorID = LAST_INSERT_ID();

INSERT INTO BookAuthors (BookID, AuthorID) VALUES (@bookID, @authorID);

COMMIT;