1-4 Lab Practicing Query Language in Codio Assignment

docx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

220

Subject

Information Systems

Date

Apr 3, 2024

Type

docx

Pages

Uploaded by brienncaervin

1-4 Lab: Practicing Query Language in Codio Creating A New Database Create a Table Called TB2

Add a Second Field

Organized Work Step-by-Step Guide to Create and Modify a Database in MytbSQL Create a New Database: Command: create database [your_last_name]; Replace [your_last_name] with your actual last name. Press Enter. List All Databases: Command: show databases; Press Enter. This will display all databases, including the one you just created. Connect to Your Database: Command: use [your_last_name]; Replace [your_last_name] with the name of the database you created. Press Enter. Capture a Screenshot: Take a screenshot of the results showing the creation and connection to your new database. Create a Table Called tb2: Command: create table tb2 (user_id VARCHAR(50)); Press Enter. List Tables in Your Database: Command: show tables; Press Enter. Describe the Table: Command: describe tb2; Press Enter. Capture a screenshot of the results. Add a New Field to the Table:

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

Command: alter table tb2 add newfield VARCHAR(25); Press Enter. Describe the Table Again: Command: describe tb2; Press Enter. Capture a screenshot showing the table with the new field.

1-4 Lab Practicing Query Language in Codio Assignment

Related Documents