Modifying views in MySQL

The VIEWS once created can be modified using ALTER statement. The syntax for view altering is:

ALTER VIEW databaseName.viewName AS

SELECT statements;

An example of ALTER VIEW below shows how to add another column to the example seen previously in the syntax:

CREATE VIEW patientInfo AS

SELECT pat.PatientID, pat.NameOfPatient, pres.fees, pres.CaseDateTime

FROM tblpatients pat

INNER JOIN tblprescription pres ON pat.PatientID=pres.PatientID;

The altered view adds the fees charged to the patient in the hospital. The modified table can be viewed using:

SELECT * FROM patientInfo;