- Lab
-
Libraries: If you want this lab, consider one of these libraries.
- Cloud

Creating Indexes in MySQL
The MySQL server allows us to create indexes, which improves the speed of operations within a database table. In this Lab, we will be creating new indexes on existing tables, creating a new table with an index, and deleting an existing index from a table. Completing this lab will demonstrate a working knowledge of indexes in MySQL.

Lab Info
Table of Contents
-
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;
-
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);
-
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);
-
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));
-
Challenge
Delete the `capital` Index on the `country` Table
Run the following command to delete the
capital
index:mysql> DROP INDEX capital ON country;
About the author
Real skill practice before real-world application
Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.
Learn by doing
Engage hands-on with the tools and technologies you’re learning. You pick the skill, we provide the credentials and environment.
Follow your guide
All labs have detailed instructions and objectives, guiding you through the learning process and ensuring you understand every step.
Turn time into mastery
On average, you retain 75% more of your learning if you take time to practice. Hands-on labs set you up for success to make those skills stick.