figure out why I keep getting a syntax error any help is greatly appreciated!!

 

You should already have completed the tutorial on getting started with Codio before you begin this lab. Go to your Codio lab environment and start a new terminal session to complete this assignment. Then, follow the steps below to 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 exact way that they appear in your instructions. To show that the commands you've written worked, capture them with a screenshot and place them in a document for submission. Your work should be organized like the Module One Lab Screenshot Example.

Look at the Additional Support section in the Resources area of this module for information that will assist you as you work through this lab.

Follow the steps shown below:

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>:
   
   1. create database last_name_here;
      
      1. For example, if your database is going to be named Jetson, then substitute Jetson for "last_name_here."
      2. Press Enter.
   2. show databases;
      1. Press Enter.
      2. You should see a listing of all of the databases (or schemas) in MySQL, including the one you just created.
   3. use last_name_here;
      1. Press Enter.
      2. 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.

 

Filetree RELBE Codio Project File Edit Find View Tools Education Help Run Python (tkinter) Virtual Desktop RELBE Configure.... 14 Guide Terminal DAD-220 SQL La... Welcome to Ubuntu 14.04.4 LTS (GNU/Linux 5.4.0-1080-aws x86_64) * Documentation: https://help.ubuntu.com/ * Welcome to the Codio Terminal! DAD-220 SQL Lab Environ https://docs.codio.com/develop/develop/ide/boxes/overview .ssh _pycache_ sqlite staruml tkinterpy .settings change_perm.sh create * Your Codio Box domain is: gopherbaron-bucketlagoon.codio.io Last login: Wed Aug 31 23:49:51 2022 from 192.168.10.226 codio@gopherbaron-bucketlagoon:~/workspaces mysql>: mysql> create database Johnson; ERROR 1064 (42000) at line 2: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the r ight syntax to use near 'mysql> create database Johnson' at line 1 codio@gopherbaron-bucketlagoon:~/workspace$ Create customers.csv FleetMaintenance Recor mysqlsampledatabase.s orders.csv README.md rma.csv Show