Database - Alter table

create table infoprib(nip varchar(5) primary key not null, nama varchar(25), kota varchar(15),
tgl_lahir date, sex char(1));
describe infoprib;
insert into infoprib values
('12348','Dita Nurafni','Klaten','1982/09/01','W'),
('12349','Dhani Akbar','Yogya','1981/05/13','L'),
('12350','Aan Setiawan','Yogya','1981/05/07','L'),
('12351','Raul Sitompul','Bantul','1979/04/05','L'),
('12352','Rahmanda','Yogya','1982/08/04','W'),
('12353','Niken','Klaten','1983/10/16','L'),
('12354','Ineke Safitri','Bantul','1983/12/30','W');


alter table infoprib change sex jenis_kelamin char(1);
alter table infoprib add gaji int;

update infoprib;
set tgl_lahir='1982/09/01'
where nip='12348';
update infoprib set tgl_lahir='1981/10/19' where nip='12348';
select * from infoprib;
where nama='Dita Nurafni';
update infoprib
set gaji = 500000 where nip = '12348';
rename table infoprib to cvpribadi;
select*from cvpribadi;
select nama, kota from cvpribadi where kota='yogya' and jenis_kelamin='L';
select*from cvpribadi where nip between 12348 and 12350;
select nip, nama from cvpribadi where kota='klaten';
select nama, kota from cvpribadi where kota IN('Yogya','Klaten');
select nama, kota from cvpribadi where kota NOT IN('Yogya','Klaten');
select*from cvpribadi order by nama;
select distinct kota from cvpribadi;
delete from cvpribadi where nip=12348;
select*from cvpribadi;