Trigger,View,Storeed Procedure pada sql yoq

SELECT * FROM mahasiwa;

SELECT nim,nama FROM mahasiswa;

SELECT * FROM mahasiswa WHERE agama=1;

SELECT * FROM mahasiswa WHERE SUBSTR(nim,5,4)='2013';

select * from mahasiswa order by nim desc limit 1;

select * from mahasiswa where isnull(tempat_lahir);

INSERT INTO mahasiswa
            (nim,
             nama,
             jkel)

VALUES ('A11.2013.001',
        'abc',
        2);

DELETE FROM mahasiswa WHERE nim='A11.2013.001';

UPDATE mahasiswa
SET tempat_lahir = 'SEMARANG',agama=2
WHERE nim = 'A11.2013.1400';


SELECT mahasiswa.*,tabel1.nim,tabel2.nilai_uas
FROM mahasiswa
  RIGHT JOIN hasil_nilai AS tabel1
    ON (mahasiswa.nim = tabel1.nim)
  RIGHT JOIN hasil_nilai AS tabel2
    ON (mahasiswa.nim = tabel2.nim);

select sum(nilai_uts) from hasil_nilai group by nim;   
   
select *
from mahasiswa
where nim not in(select nim from hasil_nilai);

select * from mahasiswa where nim like "a%";

select count(nim) as jum from mahasiswa;

SELECT
  nim,
  nama,
  IF(jkel=1,"PRIA","WANITA") AS jkel,
  CASE agama WHEN 1 THEN "ISLAM"
  WHEN 2 THEN "KATOLIK"
  WHEN 3 THEN "KRISTEN"
  END AS agama
FROM mahasiswa;

(select kode_matakuliah,nama_matakuliah,jadwal1 as jadwal from jadwal_kuliah)
union
(SELECT kode_matakuliah,nama_matakuliah,jadwal2 as jadwal FROM jadwal_kuliah);

//cara menggunakan VIEW

select * from bio_mahasiswa

select * from mahasiswa_view


//cara menggunakan stored procedure

call pro_bio_mahasiswa("A11.2013.1400")

call pro_cari_data_mahasiswa(2)


//cara menggunakan trigger
//gunakan query ini, maka akan secara otomatis melakukan insert ke tabel LOG

insert into hasil_nilai (nim,nilai_uts) value ('A11.2012.0009',20.38)

Share on Google Plus

About oralucu

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.