create database data_diri;
use data_diri;
create table infoprib (nip varchar(10)primary key,nama varchar(15),kota varchar(10),tgl_lhr date, sex char(1));
desc infoprib;
insert into infoprib values('12345','Dian Permana','Magelang','1969-03-10','L');
insert into infoprib values('12346','Tamara','yogyakarta','1980-01-01','W');
insert into infoprib values('12347','Dara Puspita','Semarang','1969-03-06','W');
insert into infoprib values('12348','Dhani Akbar','Jakarta','1989-05-31','L');
insert into infoprib values('12349','Dian Permana','Magelang','1981-05-07','L');
select*from infoprib;
update infoprib
set tgl_lhr='1989-10-17'
where nip='12345';
update infoprib
set kota='surabaya'
where nip='12347';
update infoprib
set nama='Tamara Sukma',
kota='pekanbaru'
where nip='12346';
update infoprib
set nama='Amelia Sari',
sex='W'
where nip='12349';
update infoprib
set tgl_lhr='1991-06-26'
where nama='Dhani Akbar';
update infoprib
set kota='Semarang'
where nip='12348' or nip='12349';