- Lab
- 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.
Path 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 -pUse the
worlddatabase:mysql> USE world; -
Challenge
Create an Index Called `population` on the `city` Table Using the `Population` Column
Run the following command to create the
populationindex: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
primarylanguageindex: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
countryexportstable 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
capitalindex:mysql> DROP INDEX capital ON country;
What's a lab?
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.
Provided environment for hands-on practice
We will provide the credentials and environment necessary for you to practice right within your browser.
Guided walkthrough
Follow along with the author’s guided walkthrough and build something new in your provided environment!
Did you know?
On average, you retain 75% more of your learning if you get time for practice.