CREATE TABLE classics (
author VARCHAR(128),
title VARCHAR(128),
category VARCHAR(16),
year SMALLINT,
isbn CHAR(13),
INDEX(author(20)),
INDEX(title(20)),
INDEX(category(4)),
INDEX(year),
PRIMARY KEY (isbn)) ENGINE InnoDB;
INSERT INTO classics(author, title, category, year, isbn)
VALUES('Mark Twain','The Adventures of Tom Sawyer','Fiction','1876','6578484949');
INSERT INTO classics(author, title, category, year, isbn)
VALUES('Jane Austen','Pride and Prejudice','Fiction','1811', '18565645');
INSERT INTO classics(author, title, category, year, isbn)
VALUES('Charles Darwin','The Origin of Species','Non-Fiction','1856','47657583');
INSERT INTO classics(author, title, category, year, isbn)
VALUES('Charles Dickens','The Old Curiosity Shop','Fiction','1841', '4532924');
INSERT INTO classics(author, title, category, year, isbn)
VALUES('William Shakespeare','Romeo and Juliet','Play','1594', '1987655');
SELECT * FROM classics;