Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE PROCEDURE jewish(x_imie varchar(100), x_nazwisko varchar(100))
- BEGIN
- DECLARE var_pesel varchar(100);
- DECLARE k_plec INT;
- DECLARE plec char(1);
- SELECT pesel INTO var_pesel FROM klienci WHERE Imie = x_imie and Nazwisko = x_nazwisko;
- SET k_plec = SUBSTR(var_pesel, 10, 1);
- IF MOD(k_plec,2)=0 THEN
- SET plec = "K";
- ELSE
- SET plec = "M";
- END IF;
- SELECT x_imie, x_nazwisko, plec;
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement