Laboratoriya ishi Mavzu: sql da funksiyalar yaratish. Ishdan maqsad

Begin- protseduraning SQL kodini boshlash, kod oxirini tugatish
RETURN (result); - bu kalit so'z, shundan so'ng funktsiya qaytishi kerakligi aytiladi. Funktsiya kodi har doim qaytishni ko'rsatishi kerak.
2-Misol: Plus nomli funksiya yaratish.

CREATE FUNCTION plus(a int,b int) RETURNS int

DETERMINISTIC

BEGIN

DECLARE result INT;

SET result = a+b;

RETURN (result);

END//

Query OK, 0 rows affected (0.15 sec)

mysql> DELIMITER ;

Natija:

mysql> select plus(10,45);

+-------------+

| plus(10,45) |

+-------------+

| 55 |

+-------------+

1 row in set (0.32 sec)

3-Misol:

DELIMITER //

mysql> DROP FUNCTION IF EXISTS fio//

Query OK, 0 rows affected, 1 warning (0.06 sec)

CREATE FUNCTION fio(

`name` TEXT CHARSET utf8,

`surname` TEXT CHARSET utf8,

`patronymic` TEXT CHARSET utf8

)

RETURNS TEXT CHARSET utf8

READS SQL DATA

BEGIN

RETURN CONCAT(

`surname`,

' ',

SUBSTRING(`name`, 1, 1),

'. ',

SUBSTRING(`patronymic`, 1, 1),

'.');

END//

Query OK, 0 rows affected, 4 warnings (0.12 sec)
Natija:

mysql> select FIO('Malohat',' Burxonova','Mamirovna');

-> //

+-----------------------------------------+

| FIO('Malohat',' Burxonova','Mamirovna') |

+-----------------------------------------+

| Burxonova M. M. |

+-----------------------------------------+

1 row in set (0.00 sec)

DROP FUNCTION IF EXISTS fio//

Query OK, 0 rows affected, 1 warning (0.07 sec)

Natija:2

mysql> select fio (fam,ism,O_i) from abiturent;

-> //

+-------------------+

| fio (fam,ism,O_i) |

+-------------------+

| Malika K. S. |

| Jasur O. A. |

| Jasur A. D. |

| Temur I. Q. |

| Asil T. E. |

| Farruh A. B. |

| Jahongir A. A. |

| Axror D. U. |

| Malohat U. A. |

| Jasur O. T. |

| Alisher K. G. |

| Akrom T. S. |

| Akrom M. I. |

| Akmal J. K. |

| Salim M. T. |

| Obid X. H. |

| Asil Y. A. |

| Umid T. A. |

| Adham B. K. |

+-------------------+

19 rows in set (0.11 sec)
Topshiriq: Har bir talaba quyidagi funksiyani yaratishi va natijasi bilan ko’rsatib o’tishi kerak.

№	Funksiya nomi
1.	Minus
	Bo’lish
	Ildiz
	Modul
	Ustunlarni birlashtirish
	Mavjud standart funksiyalar(10-lab)dan foydalanib yangi funksiya yaratish.