TASKS to Complete:

Create a database named mySQL$\_$firstname$\_$your lastname. For example, if your name is John Smith, the database name must be mySQL$\_$JOHN$\_$SMITH. Use this database to complete all of the following tasks. See below.

CREATE DATABASE mySQL$\_$your firstname$\_$your lastname;

Type the following statements and display the results.

USE mySQL$\_$ your firstname$\_$your lastname;

SELECT current$\_$user$(),$ now$(),$ database$()$;

Type the following command to create a table with your name.

CREATE TABLE ex$\_$ your firstname$\_$your lastname

$($ ID integer primary key,

FNAME varchar$(25),$

LNAME varchar$(25))$;

Type the following command to display the structure of the table.

DESCRIBE ex$\_$ your firstname$\_$your lastname;

Type the following command to insert a record $($with your first and last name$)$ into the table ex$\_$ your firstname$\_$your lastname.

INSERT INTO ex$\_$ your firstname$\_$your lastname

VALUES $(100,$your firstname$,$your lastname$)$;

Type the following command to display the records from the table ex$\_$ your firstname$\_$your lastname.

SELECT $*$ FROM ex$\_$ your firstname$\_$your lastname;