Working with databases and tables is a foundational skill for any database administrator. This ability to create multiple databases and multiple tables within each database allows administrators to ensure that data is grouped in a logical order. In this lab, you will walk through creating and deleting databases and tables in a MySQL server.
Learning Objectives
Successfully complete this lab by achieving the following learning objectives:
- Log into the MySQL Database
As the cloud_user, run the following command and enter the password from the instructions (under Additonal Information) when prompted:
# mysql -u root -p- Delete the `bad_data` Database from the MySQL Server
In the
mysqlprompt, run the following command:mysql> DROP DATABASE bad_data;- Create a Database Named `customer_info`
In the
mysqlprompt, run the following command:mysql> CREATE DATABASE customer_info;- Delete the Table `payment_info` from the `2004_data` Database
In the
mysqlprompt, change the database to2004_data:mysql> USE 2004_data;Drop the
payment_infotable:mysql> DROP TABLE payment_info;- Create a Table Named `payment_info` in the `customer_info` Database According to the Characteristics Provided in the Instructions
Change the database to
customer_info:mysql> USE customer_info;Create the
payment_infotable with the characteristics provided:mysql> CREATE TABLE payment_info (cust_id INT AUTO_INCREMENT PRIMARY KEY, user_name VARCHAR(50) UNIQUE, card_number INT, purchase_item VARCHAR(255));Verify that the table was created as expected:
mysql> DESCRIBE payment_info;Exit the mysql prompt:
mysql> exit
