student

create table student(id int,name varchar(20),age int,class varchar(20));
insert into student values(1,'vasu',22,'btech');
insert into student values(2,'sadineni',23,'mtech');
insert into student values(3,'sai',25,'ms');
insert into student values(4,'hari',20,'diploma');
insert into student values(5,'manu',28,'job');
insert into student values(6,'karthik',23,'job');
insert into student values(7,'rajesh',21,'btech');
insert into student values(8,'vishnu',30,'tcsjob');
insert into student values(9,'sainath',21,'startup');
insert into student values(10,'venkat',26,'masters');
selectfrom student;
alter table student add(nativeplace varchar(30));
select from student;
insert into student(id,name,age,class,nativeplace) values(11,'krish',24,'job','pulipadu');
select * from student;
alter table student add(joblocation varchar(30));
alter table student add(salary int);
selectfrom student;
update student set joblocation='hyderbad' where name='vasu';
update student set nativeplace='pulipadu' where id=1;
update student set salary=10000 where id=1;
update student set nativeplace='Gurazala' where id=2;
update student set joblocation='bangalore' where name='sadineni';
update student set salary=20000 where id=2;
update student set nativeplace='khammam' where id=3;
update student set joblocation='vadodara' where id=3;
update student set salary=25000 where id=3;
update student set nativeplace='warangal'where age=20;
alter table student add(phonenumber varchar(10));
selectfrom student;
update student set phonenumber=7075430854 where name='vasu';
update student set joblocation='chennai'where name='hari';
update student set salary=30000 where name='hari';
update student set salary=30000 where name='manu';
update student set phonenumber=7075420854 where name='sadineni';
update student set phonenumber=7075420854;
update student set salary=salary+2000 where id=1;
alter table student add(expereince int);
selectfrom student;
update student set expereince=2;
selectfrom student;
desc student;