Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- Autor : Joel Fernandez
- Fecha : 08/10/2015
- IDE : MySQL Workbench
- Web : www. codebotic.com
- Tema : FUnciones en MySQL
- */
- --1° Comprobar si un numero es primo o no
- DELIMITER $$
- CREATE FUNCTION primo( num int)
- RETURNS INT
- BEGIN
- DECLARE num INT;
- DECLARE cont INT DEFAULT 0;
- DECLARE i INT;
- SET i = 1;
- bucle: WHILE i<=num DO
- IF num%i = 0 THEN
- SET cont = cont +1;
- SET i = i+1;
- END IF;
- END WHILE bucle;
- IF cont = 2 THEN
- return 1;
- ELSE
- return 0;
- END IF;
- END;
- $$
- -- Ejemplo:
- select * from primo(7);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement