Setting Up MySQL Database with Last Name and Table Fields - Edubirdie

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

Related Documents

Setting Up MySQL Database with Last Name and Table Fields

Setting Up MySQL Database with Last Name and Table Fields - Page 1

Setting Up MySQL Database with Last Name and Table Fields - Page 2

Setting Up MySQL Database with Last Name and Table Fields - Page 3

of 3

Recommended Documents

Analysis and Summary Template

Analysis and Summary Template

Southern New Hampshire University DAD220 | Introduction to Structured Database Environments

Assignment

Module Four Major Activity Database Documentation Template

Module Four Major Activity Database Documentation Template

Southern New Hampshire University DAD220 | Introduction to Structured Database Environments

Assignment

Module Three Major Activity Database Documentation Template

Module Three Major Activity Database Documentation Template

Southern New Hampshire University DAD220 | Introduction to Structured Database Environments

Assignment

7-1 Project Two: Analyzing Databases

7-1 Project Two: Analyzing Databases

Southern New Hampshire University DAD220 | Introduction to Structured Database Environments

Assignment

Database Documentation Template

Database Documentation Template

Southern New Hampshire University DAD220 | Introduction to Structured Database Environments

Assignment

Database Lab: Permissions, Renaming, Joins, Extraction

Database Lab: Permissions, Renaming, Joins, Extraction

Southern New Hampshire University DAD220 | Introduction to Structured Database Environments

Assignment

New Documents from this Course

Analysis and Summary Template

Analysis and Summary Template

Southern New Hampshire University DAD220 | Introduction to Structured Database Environments

Assignment