mysql创建图书数据库表

CREATE DATABASE 图书;

USE 图书;

CREATE TABLE books (
  id INT AUTO_INCREMENT PRIMARY KEY,
  title VARCHAR(255) NOT NULL,
  author VARCHAR(255) NOT NULL,
  price DECIMAL(10, 2),
  publication_date DATE
);

INSERT INTO books (title, author, price, publication_date) VALUES
  ('MySQL in Action', 'Bill Karwin', 39.99, '2020-01-01'),
  ('The Art of SQL', 'Stephane Faroult', 45.50, '2019-05-15'),
  ('Database Systems: The Complete Book', 'Hector Garcia-Molina', 55.00, '2018-10-30');