Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- delimiter //
- CREATE PROCEDURE prowizja()
- begin
- SELECT concat(imie, " ", nazwisko) as imie_i_nazwisko, sum(suma) as suma, sum(suma) * (5/100) as prowizja_5_proc FROM kelnerzy
- JOIN zamowienia ON zamowienia.id_kelnera = kelnerzy.id_kelnera
- JOIN faktury on zamowienia.id_faktury = faktury.id_faktury
- WHERE date(zamowienia.data) = curdate()
- GROUP BY kelnerzy.id_kelnera;
- end //
- delimiter ;
- delimiter //
- CREATE TRIGGER aktualizacja_pizzy
- BEFORE UPDATE
- ON skladniki FOR EACH ROW
- begin
- INSERT INTO kopia_skladnikow SELECT 0, id_pizzy, id_skladnika, NOW() data FROM skladniki WHERE skladniki.id_pizzy = old.id_pizzy;
- end //
- delimiter ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement