Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT siswa.idsiswa, siswa.nama_siswa, mata_pelajaran.nama_mp, guru.nama_guru, nilai.nilai FROM siswa, mata_pelajaran, guru, nilai WHERE siswa.idsiswa=nilai.idsiswa;
- DELIMITER |
- CREATE PROCEDURE Getdata()
- BEGIN
- SELECT siswa.idsiswa, siswa.nama_siswa, mata_pelajaran.nama_mp, guru.nama_guru, nilai.nilai FROM siswa, mata_pelajaran, guru, nilai WHERE siswa.idsiswa=nilai.idsiswa;
- END;
- START TRANSACTION
- UPDATE siswa SET alamat='' WHERE idsiswa='';
- COMMIT;
- CREATE TABLE temporary(
- idsiswa VARCHAR (20) NOT NULL,
- nama VARCHAR (50) NOT NULL,
- waktu VARCHAR(100) NOT NULL,
- PRIMARY KEY (idsiswa)
- );
- DELIMITER |
- CREATE TRIGGER hapus_data AFTER DELETE
- ON siswa FOR EACH ROW
- BEGIN
- INSERT INTO temporary SET
- idsiswa=old.idsiswa, nama=nama_siswa, waktu=now();
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement