CREATE TABLE IF NOT EXISTS `employees_example` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `first_name` varchar(30) NOT NULL,

  `last_name` varchar(40) NOT NULL,

  `position` varchar(25) NOT NULL,

  `home_address` varchar(50) NOT NULL,

  `home_phone` varchar(12) NOT NULL,

  `employee_code` varchar(25) NOT NULL,

  PRIMARY KEY (`id`),

  UNIQUE KEY `employee_code` (`employee_code`),

  KEY `first_name` (`first_name`,`last_name`)

) ;

​

INSERT INTO `employees_example` (`first_name`, `last_name`, `position`, `home_address`, `home_phone`, `employee_code`)

  VALUES

  ('Mustapha', 'Mond', 'Chief Executive Officer', '692 Promiscuous Plaza', '326-555-3492', 'MM1'),

  ('Henry', 'Foster', 'Store Manager', '314 Savage Circle', '326-555-3847', 'HF1'),

  ('Bernard', 'Marx', 'Cashier', '1240 Ambient Avenue', '326-555-8456', 'BM1'),

  ('Lenina', 'Crowne', 'Cashier', '281 Bumblepuppy Boulevard', '328-555-2349', 'LC1'),

  ('Fanny', 'Crowne', 'Restocker', '1023 Bokanovsky Lane', '326-555-6329', 'FC1'),

  ('Helmholtz', 'Watson', 'Janitor', '944 Soma Court', '329-555-2478', 'HW1');

​

SHOW INDEXES FROM employees_example;