LPMJ Example 8-11

(Click on the icon to view the source for copy and pasting)

ALTER TABLE classics ADD INDEX(author(20));
CREATE INDEX author ON classics (author(20));