GPT答：

7i24.cn

CREATE TABLE tb_book (
  bookid INT NOT NULL AUTO_INCREMENT,
  bookname VARCHAR(50) NOT NULL,
  author VARCHAR(50) NOT NULL,
  publisher VARCHAR(50) NOT NULL,
  price DECIMAL(8,2) NOT NULL,
  PRIMARY KEY (bookid),
  INDEX idx_bookname (bookname)
);