Using Alter Statement we Can Modify column name Add column and Change Data Types
ADD Statement
ALTER TABLE QueryPanel_Employees ADD COLUMN shift VARCHAR(255);
MODIFY Statement
ALTER TABLE QueryPanel_employees MODIFY COLUMN shift char(25);
CHANGE NAME
ALTER TABLE QueryPanel_employees CHANGE COLUMN shift shift_time varchar(225);
DROP COLUMN
ALTER TABLE QueryPanel_employees DROP COLUMN Shift_time;
MULTIPLE COLUMN ADD
ALTER TABLE QueryPanel_employees ADD COLUMN Shift VARCHAR(255),ADD COLUMN Timing DATETIME(6);
