Testing site manage patient.
——create database:
create table patient( PatientID int NOT NULL AUTO_INCREMENT,
FirstName CHAR(50) NOT NULL,
LastName CHAR(50) NOT NULL,
DateOfBirth date, Gender char(6), PhoneNumber char(10), Email char(30), Height int, Weight int, BloodGroup char(3), CreateOn date , ModifiedOn date,
PRIMARY KEY (PatientID)
);
——-insert data:
insert into patient(FirstName, LastName, DateOfBirth, Gender, PhoneNumber, Email, Height, Weight, BloodGroup, CreateOn, ModifiedOn)
VALUES
(‘bob’, ‘ross’, ‘2000-1-12’, ‘male’, ‘0123433789’, ‘dat@mail.com’, 179, 52, ‘B’, CURRENT_DATE, CURRENT_DATE),
(‘trang’, ‘nguyen’, ‘1990-12-12’, ‘female’, ‘0333456789’, ‘dat@mail.com’, 169, 52, ‘B’, CURRENT_DATE, CURRENT_DATE),
(‘dong’, ‘le’, ‘2000-4-4’, ‘female’, ‘0123458899’, ‘dat@mail.com’, 180, 52, ‘O’, CURRENT_DATE, CURRENT_DATE),
(‘chau’, ‘nguyen’, ‘2000-5-6’, ‘male’, ‘0223336789’, ‘dat@mail.com’, 169, 51, ‘B’, CURRENT_DATE, CURRENT_DATE),
(‘hong’, ‘tran’, ‘2000-5-3’, ‘female’, ‘0223456789’, ‘dat@mail.com’, 169, 52, ‘A’, CURRENT_DATE, CURRENT_DATE),
(‘travitt’, ‘scot’, ‘2000-13-12’, ‘male’, ‘0133456789’, ‘dat@mail.com’, 169, 52, ‘O’, CURRENT_DATE, CURRENT_DATE),
(‘ba’, ‘ly’, ‘2001-12-3’, ‘male’, ‘0123556789’, ‘dat@mail.com’, 169, 52, ‘A’, CURRENT_DATE, CURRENT_DATE),
(‘bin’, ‘nguyen’, ‘2000-12-1’, ‘female’, ‘0123446789’, ‘dat@mail.com’, 169, 52, ‘O’, CURRENT_DATE, CURRENT_DATE);