-- 使用 bookstore 数据库
USE bookstore;

-- 向 book 表插入数据
INSERT INTO book (book_id, title, author, price)
VALUES 
(1, 'Python Crash Course', 'Eric Matthes', 29.99),
(2, 'Clean Code', 'Robert C. Martin', 39.99),
(3, 'Effective Java', 'Joshua Bloch', 49.99);

-- 向 members 表插入数据
INSERT INTO members (member_id, name, email)
VALUES 
(1, 'John Doe', 'john.doe@example.com'),
(2, 'Jane Smith', 'jane.smith@example.com'),
(3, 'Bob Johnson', 'bob.johnson@example.com');

-- 向 sell 表插入数据
INSERT INTO sell (sell_id, book_id, member_id, sell_date)
VALUES 
(1, 1, 1, '2024-01-01'),
(2, 2, 2, '2024-02-15'),
(3, 3, 3, '2024-03-20');