Answer Happy

Overview Codio is an online integrated development environment(IDE) where you’ll perform the labs for this course. In thisassignment, you’ll practice using structured query language, orSQL, in Codio. Directions Note: You should already have completedthe tutorial on getting started with Codio before you begin thislab. Go to your Codio lab environment and start a new terminalsession to complete this assignment. Then, follow the steps belowto get practice with MySQL. SQL needs very specific input language.It’s important to note that spelling, capitalization, letters,numbers, and punctuation marks must be entered into Codio the exactway that they appear in your instructions. To show that thecommands you’ve written worked, capture them with a screenshot andplace them in a document for submission. Your work should beorganized like the Module One Lab Screenshot Example. Look at theAdditional Support section in the Resources area of this module forinformation that will assist you as you work through this lab. Tocomplete this lab, follow the steps shown below: Create a newdatabase and update the name to your last name, then connect to it.Type the following commands after the prompt mysql>: createdatabase last_name_here; For example, if your database is going tobe named Jetson, then substitute Jetson for “last_name_here.” PressEnter. show databases; Press Enter. You should see a listing of allof the databases (or schemas) in MySQL, including the one you justcreated. use last_name_here; Press Enter. Substitute the name ofyour database (for example, Jetson) for “last_name_here”. This SQLstatement connects your MySQL session to the database you’ve justcreated. Capture a screenshot or clipping of the results of thisaction, and place it in a Word document for submission. Create atable called tb2 and list out the tables in your database with onefield by typing the following commands after the prompt mysql>:create table tb2 (user_id VARCHAR( 50 )); Press Enter. show tables;Press Enter. describe tb2; Press Enter. Capture a screenshot orclipping of the results of this action, and place it in a Worddocument for submission. Add a second field into the table anddescribe it. Do this by entering the following commands aftermysql>: alter table tb2 add newfield VARCHAR(25); Press Enter.describe tb2; Press Enter. Capture a screenshot or clipping of theresults of this action, and place it in a Word document forsubmission. Organize your work by following the guidelinespresented in the example mentioned above. Follow standardguidelines for submitting the work to show that commands you’vewritten for this lab worked.