用mysql做图书管理代码

CREATE TABLE authors (
    author_id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL
);

CREATE TABLE publishers (
    publisher_id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL
);

CREATE TABLE books (
    book_id INT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255) NOT NULL,
    author_id INT,
    publisher_id INT,
    publication_date DATE,
    FOREIGN KEY (author_id) REFERENCES authors(author_id),
    FOREIGN KEY (publisher_id) REFERENCES publishers(publisher_id)
);

INSERT INTO authors (name) VALUES ('J.K. Rowling'), ('George Orwell');
INSERT INTO publishers (name) VALUES ('Bloomsbury'), ('Secker & Warburg');
INSERT INTO books (title, author_id, publisher_id, publication_date) VALUES 
('Harry Potter and the Philosopher\'s Stone', 1, 1, '1997-06-26'),
('1984', 2, 2, '1949-06-08');

SELECT b.title, a.name AS author, p.name AS publisher, b.publication_date
FROM books b
JOIN authors a ON b.author_id = a.author_id
JOIN publishers p ON b.publisher_id = p.publisher_id;