University:
Southern New Hampshire University
Course:
DAD220 | Introduction to Structured Database Environments
Academic year:

2023
Views:

395

Pages:

3
Author:

Cameron T.

Cameron Thistle DAD 220 SNHU 03-08-2023 1. Create a new database and update the name to your last name, then connect to it. Type the following commands after the prompt mysql> a. Create database Thistle I. Press Enter. b. show databases; I. Press Enter. c. use Thistle; I. Press Enter. 2. Create a table called tb2 and list out the tables in your database with one field by typing the following commands after the prompt mysql> a. create table tb2 (user_id VARCHAR( 50 )); I. Press Enter. b. show tables; I. Press Enter. c. describe tb2; I. Press Enter. 3. Now, add a second field by entering the following commands after mysql> a. alter table tb2 add newfield VARCHAR(25); I. Press Enter. b. describe tb2; I. Press Enter