prepare stmt1
from 'SELECT SQRT(POW(?,2) + POW(?,2)) AS `Гипотенуза`';
SET @a = 3;
SET @b = 4;
execute stmt1 USING @a, @b;
prepare stmt2
from 'select * from STUDENTS where team = ?';
set @c = 1;
execute stmt2 USING @c;
DEALLOCATE PREPARE stmt1;
DEALLOCATE PREPARE stmt2;
DROP PROCEDURE IF EXISTS Count_rabota \]
CREATE PROCEDURE Count_rabota(OUT total INT)
BEGIN
SELECT COUNT(*) INTO total FROM WORK;