shop

create table shop(id int,name varchar(20),totalitems int,chocolate int,biscuit int,grocery int);
insert into shop values(1,'vasu',5,1,1,3);
insert into shop values(2,'sadineni',5,2,1,2);
insert into shop values(3,'hari',5,0,2,3);
insert into shop values(4,'manu',5,3,0,2);
insert into shop values(5,'krish',5,2,1,2);
selectfrom shop;
alter table shop add(chicken int);
selectfrom shop;
insert into shop(id,name,totalitems,chocolate) values(6,'jay',5,5);
selectfrom shop;
desc shop;
update shop set grocery='2' where name='jay';
selectfrom shop;
update shop set chicken='4';
selectfrom shop;
update shop set chicken='1' where name='vasu';
selectfrom shop;
update shop set biscuit='4'where name='jay';
select * from shop;
alter table shop add(salary int);
selectfrom shop;
update shop set salary='10000';
select from shop;
update shop set salary=salary+2000;
selectfrom shop;
update shop set salary=salary+5000 where name='vasu';
selectfrom shop;
update shop set name='venkata' where name='jay';
selectfrom shop;
alter table shop add(yearsexperince int);
selectfrom shop;
update shop set yearsexperince='2';

select*from shop;