Форум пользователей MySQL

drop procedure IF EXISTS write_new_person;

DELIMITER |
CREATE PROCEDURE write_new_person(IN person_name VARCHAR(100), IN person_priority VARCHAR(3), IN person_sometext TEXT, IN numbers TEXT, IN descriptions TEXT, IN groups TEXT, IN tabs TEXT, OUT ou INT)
BEGIN  
   
    #koli4estvo sovpadenui v stroke
    DECLARE count_res INT;
   
    SELECT count(0) AS count_res FROM `persons_book` WHERE `person_name`='test';
    SET ou = count_res;
END|
DELIMITER ;