create table IF NOT EXISTS College(
    ID int(1),
    Name text(20),
    Stipend text(8), 
    Subject text(17),
    Percentage int(2),
    Position text(2)
);

Insert into College values(1,"Anuj",4000,"English",65,"P1"); 
Insert into College values(2,"Ashu",4500,"History",60,"P2"); 
Insert into College values(3,"Ruby",3500,"English",55,"P2"); 
Insert into College values(4,"Raman",3800,"Math",58,"P3"); 

select * from College; 

-- UPDATE 

update College 
set Stipend = 9000
where Name = "Ashu";

update College 
set Stipend = 9000, Subject = "Computer"
where Name = "Ashu";

select * from College; 


-- ALTER 

-- ADDING A NEW COLUMN 
ALTER TABLE College 
ADD Email varchar(255); 


-- ADDING MULTIPLE COLUMNS 

ALTER TABLE College 
ADD address varchar (100) not null 
After Subject, 
Add gender text (10) 
after Name; 

select * from College; 

-- DROP COLUMN 
ALTER TABLE College 
DROP COLUMN Email; 

select * from College; 

ALTER TABLE College 
MODIFY COLUMN Name Varchar(100); 

desc College; 

-- RENAME COLUMN 
ALTER TABLE College 
RENAME COLUMN Name to Student_name; 

select * from College;