Advertisement
Guest User

Untitled

a guest
Jan 28th, 2015
198
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.28 KB | None | 0 0
  1. delimiter //
  2. CREATE FUNCTION zad3(a INT, b INT) RETURNS INT
  3. BEGIN
  4.   DECLARE wynik INT DEFAULT 0;
  5.   while a<b do SET a=a+1;
  6.     IF(MOD(a,2)=0 AND MOD(a,3)!=0) THEN (SELECT (wynik+a) INTO wynik);
  7.     END IF;
  8.   END while;
  9.   RETURN wynik;
  10. END;
  11. //
  12. delimiter ;
  13.  
  14. SELECT zad3(1,10);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement