Create a table and database using your name and fill the table with the following fields a. Costumer ID b. Name c. Age d. City

 DATABASE:

DROP DATABASE IF EXISTS `IBRAR`;

CREATE DATABASE IBRAR;

USE IBRAR;

CREATE TABLE IBRAR(

CustomerID int,

FullName varchar(225),

age varchar(225),

city varchar(225)

);

SOLUTION TABLE:

Create a table from the table of Lab Task 1 and use fields Costumer ID and Name as its fields entry.

Task 2:

DROP DATABASE IF EXISTS `IBRAR`;

CREATE DATABASE IBRAR;

USE IBRAR;

 

CREATE TABLE IBRAR(

CustomerID int,

FullName varchar(225),

age varchar(225),

city varchar(225)

);

 

Create table include AS 

Select CustomerID ,FullName

From IBRAR;

SOLUTION TABLE: