LPMJ Example 8-4

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

USE publications;
CREATE TABLE classics (
author VARCHAR(128),
title VARCHAR(128),
type VARCHAR(16),
year CHAR(4)) ENGINE MyISAM;
DESCRIBE classics;