SQL - FUNCTION 23 Dec

DELIMITER //

CREATE FUNCTION hello (arguments VARCHAR(10))

RETURNS VARCHAR(100) DETERMINISTIC

BEGIN

RETURN CONCAT('Hello',arguments,'!');

END//

----------------

SELECT hello('world'); 

_______________________________

vienam un tam pašas parametriem atgriez vienu un to pašu, tad DETERMINISTIC; 

ja nav tie pasi - NOTDETERMINISTIC;

__________________________

DELIMITER //

CREATE FUNCTION hello (arguments VARCHAR(10))

RETURNS VARCHAR(100) DETERMINISTIC

BEGIN

DECLARE mainigais INT(10) DEFAULT 10;

RETURN CONCAT('Hello',arguments,'!');

END//

---------------------

SELECT hello('world');

_________________________