CREATE TABLE Customers (
  id int(11) NOT NULL default '0',
  age enum('5..30','31..40','41..100') NOT NULL default '5..30',
  income enum('low','medium','high') NOT NULL default 'high',
  student enum('no','yes') NOT NULL default 'yes',
  credit_rating enum('fair','excellent') NOT NULL default 'fair',
  buys_computer enum('no','yes') NOT NULL default 'no',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Dumping data for table `Customers`
#

INSERT INTO Customers VALUES (1, '5..30', 'high', 'no', 'fair', 'no');
INSERT INTO Customers VALUES (2, '5..30', 'high', 'no', 'excellent', 'no');
INSERT INTO Customers VALUES (3, '31..40', 'high', 'no', 'fair', 'yes');
INSERT INTO Customers VALUES (4, '41..100', 'medium', 'no', 'fair', 'yes');
INSERT INTO Customers VALUES (5, '41..100', 'low', 'yes', 'fair', 'yes');
INSERT INTO Customers VALUES (6, '41..100', 'low', 'yes', 'excellent', 'no');
INSERT INTO Customers VALUES (7, '31..40', 'low', 'yes', 'excellent', 'yes');
INSERT INTO Customers VALUES (8, '5..30', 'medium', 'no', 'fair', 'no');
INSERT INTO Customers VALUES (9, '5..30', 'low', 'yes', 'fair', 'yes');
INSERT INTO Customers VALUES (10, '41..100', 'medium', 'yes', 'fair', 'yes');
INSERT INTO Customers VALUES (11, '5..30', 'medium', 'yes', 'excellent', 'yes');
INSERT INTO Customers VALUES (12, '31..40', 'medium', 'no', 'excellent', 'yes');
INSERT INTO Customers VALUES (13, '31..40', 'high', 'yes', 'fair', 'yes');
INSERT INTO Customers VALUES (14, '41..100', 'medium', 'no', 'excellent', 'no');