CREATE TABLE folks
(
name varchar(20),
city varchar(20),
state varchar(20)
);
insert into folks(name,city,state)values('Nagadurga','Nalgonda','Telangana');
update folks
set state='TS'
where city='Nalgonda';
select*from folks;
alter table folks
add gender varchar(10);
insert into folks (name,city,state,gender)value('Nagadurga','Nalgonda','TS','Female');
select*from folks;