DbLab1 (create,add,drop,select)

CREATE DATABASE Name_Id;

USE Name_Id;

CREATE TABLE Person
(
PersonID INT,
LastName VARCHAR(255),
FirstName VARCHAR(255),
Address VARCHAR(255),
City VARCHAR(255),
);

INSERT INTO Person(PersonID,LastName,FirstName,Address,City)
VALUES (1,'box','white','ahsanullah','dhaka');

INSERT INTO Person(PersonID,LastName,FirstName,Address,City)
VALUES (2,'box2','white','dg5','dhaka1');

INSERT INTO Person(PersonID,LastName,FirstName,Address,City)
VALUES (3,'box3','white7','dg4','dhaka0');

INSERT INTO Person(PersonID,LastName,FirstName,Address,City)
VALUES (4,'box4','white','dg1','dhaka1');

INSERT INTO Person(PersonID,LastName,FirstName,Address,City)
VALUES (5,'box5','white','dg','dhaka');

SELECT * FROM Person;

SELECT DISTINCT address FROM Person;

SELECT DISTINCT FirstName,City FROM Person;

SELECT * FROM Person WHERE FirstName='white' AND LastName = 'box';

SELECT * FROM Person WHERE FirstName='white' OR LastName = 'box2';

SELECT * FROM Person WHERE LastName='box2' AND ( FirstName = 'white' OR LastName='box3');

ALTER TABLE Person
ADD age INT;

ALTER TABLE Person
DROP COLUMN age;