In this lab, we’ve been tasked with creating two new tables for our company’s corporate database. Once they’re created, we need to insert some data into each of them.
This will give us some hands-on experience in creating tables and inserting data for databases in a MySQL server.
Learning Objectives
Successfully complete this lab by achieving the following learning objectives:
- Log into the MySQL Server as `root` and Change to the `corporate` Database
Login to the MySQL server:
# mysql -u root -pChange to the corporate database:
mysql> USE corporate;- Create a Table Named `products` in the `corporate` Database with the Characteristics Provided in the Instructions
Create the products table with the following command:
mysql> CREATE TABLE products (productID INT PRIMARY KEY, productType VARCHAR(50), operatingSystem VARCHAR(50));- Create a Table Named `orders** in the `corporate` Database with the Characteristics Provided in the Instructions
Create the orders table with the following command:
mysql> CREATE TABLE orders (orderID INT PRIMARY KEY, userName VARCHAR(50) UNIQUE, orderType VARCHAR(255), purchaseDate DATE);- Insert Data into the `products` Table According to the Information Provided in the Instructions
Insert data into the products table with the following command:
mysql> INSERT INTO products (productID,productType,operatingSystem) VALUES (1,'laptop','ubuntu'),(2,'desktop','windows'),(3,'server','rhel');- Insert Data into the `orders` Table According to the Information Provided in the Instructions
Insert data into the orders table with the following command:
mysql> INSERT INTO orders (orderID,userName,orderType,purchaseDate) VALUES (1,'aaron','laptop','2018-02-23'),(2,'stosh','desktop','2018-01-25'),(3,'kenny','server','2019-12-10');
