contoh bagian 2 program sederhana sql

Mysql –u root –p
Create database mahasiswa;
Use mahasiswa;
Create table mhs (nama varchar (20),npm varchar (10) primary key,kelas varchar (10),alamat varchar (30));
Create table mkul (kdmk varchar (10) primary key,matkul varchar(10),sks varchar(5),dosen varchar(20));
Create table nilai (npm varchar (10),kdmk varchar (10),mid varchar (5),final varchar (7));
Describe mhs;
Describe mkul;
Describe nilai;
Insert into mhs values (“50407001”,”rina”,”4ia04”,”depok”);
Insert into mhs values (“50407002”,”eby”,”4ia03”,”tebet”);
Insert into mhs values (“50407003”,”angga”,”4ia05”,”cibubur”);
Insert into mhs values (“50407004”,”tri”,”4ia07”,”cempaka”);
Insert into mkul values (“1ac02”,”arkom”,”3”,”anita”);
Insert into mkul values (“1ac04”,”ap1”,”3”,”oktorio”);
Insert into mkul values (“5kb15”,”kecerdasan buatan”,”2”,”syahbuddin”);
Insert into mkul values (“4dc21”,”ibd”,”1”,”ari hasan”);
Insert into mkul values(“1ac04”,”ap1”,”3”,”oktorio”);
Insert into nilai values(“50407001”,” 1ac02”,”100”,”65”);
Insert into nilai values(“50407002”,” 2ac04”,”754”,”80”);
Insert into nilai values(“50407003”,” 5kb15”,”90”,”70”);
Insert into nilai values(“50407004”,” 4dc21”,”76”,”95”);
Select * from mhs;
Select * from mkul;
Select * from nilai;
update mhs set nama = "ari" where alamat = "tebet";
delete from mhs where nama = "ari";