DAD 220 Lab 1

docx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

DAD220

Subject

Computer Science

Date

Dec 6, 2023

Type

docx

Pages

3

Uploaded by ChiefPheasant2716

Report
DAD 220 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 last_name_here; i. For example, if your database is going to be named Jetson, then substitute Jetson for “last_name_here.” ii. Press Enter . B. show databases; i. Press Enter . ii. You should see a listing of all of the databases (or schemas) in MySQL, including the one you just created. C. use last_name_here; i. Press Enter . ii. Substitute the name of your database (for example, Jetson) for “last_name_here”. This SQL statement connects your MySQL session to the database you’ve just created. iii. Capture a screenshot or clipping of the results of this action, and place it in a Word document for submission.
Figure 1: Step 1 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 . ii. Capture a screenshot or clipping of the results of this action, and place it in a Word document for submission.
Figure 2: Step 2 3. Add a second field into the table and describe it. Do this by entering the following commands after mysql>: A. alter table tb2 add newfield VARCHAR(25); i. Press Enter . B. describe tb2; i. Press Enter . ii. Capture a screenshot or clipping of the results of this action, and place it in a Word document for submission. Figure 3: Step 3
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help

Related Documents

Parmar_1230438757_M5A1.docx
Parmar_1230438757_M8A2.docx
COMSW4701_HW2 (1).pdf
Parmar_1230438757_M4A2.docx
Deploying and implementing a cloud solution.docx
COMSW4701_HW3.pdf
What is a Flowchart _ Lucidchart.pdf
6.5.10.pdf
6.5.7.pdf
8.1.9.docx
Lab 44 (CIDR Subnetting).doc
Screen Shot 2022-09-25 at 2.57.21 PM.png
Recommended textbooks for you
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Enhanced Discovering Computers 2017 (Shelly Cashm...
Computer Science
ISBN:9781305657458
Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:Cengage Learning
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Enhanced Discovering Computers 2017 (Shelly Cashm...
Computer Science
ISBN:9781305657458
Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:Cengage Learning
SEE MORE TEXTBOOKS