Загрузка данных


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;