Table of Contents

1. Challenge

   Log into the MySQL Server as root and Use the world Database

   Log into the MySQL server, using Linux4me! as a root MySQL password:

   # mysql -u root -p
   

   Use the world database:

   mysql> USE world;
   

2. Challenge

   Create an Index Called `population` on the `city` Table Using the `Population` Column

   Run the following command to create the population index:

   mysql> CREATE INDEX population ON city(Population);
   

3. Challenge

   Create an Index Called `primarylanguage` on the `countrylanguage` Table Using the `Language` and `IsOfficial` Columns

   Use the following command to create the primarylanguage index:

   mysql> CREATE INDEX primarylanguage ON countrylanguage(Language,IsOfficial);
   

4. Challenge

   Create a New Table Named `countryexports` in the `world` Database Using the Information Provided in the Instructions

   Create the countryexports table using the following command:

   mysql> CREATE TABLE countryexports (Code CHAR(3) PRIMARY KEY, Name CHAR(52), Export VARCHAR(120), Quantity INT, INDEX export (Export));
   

5. Challenge

   Delete the `capital` Index on the `country` Table

   Run the following command to delete the capital index:

   mysql> DROP INDEX capital ON country;