Процедура mysql

первый раз пишу процедуру в mysql пожалуйста поправьте меня

DELIMITER // 
CREATE PROCEDURE `proc_IN` (IN var1 INT) 
BEGIN 
    DECLARE a INT;
    DECLARE TimeN TEXT;
    SET a = SELECT COUNT(old_idPersonalClothing) FROM PersonalClothing WHERE old_idPersonalClothing = var1;
    IF a = 1 THEN
        SET TimeN = Select `TimeN` from Clothing, PersonalCLothing WHERE `idClothing`=`idClothing1` and `IdPersonal` = var1;
        UPDATE PersonalClothing SET Fact=Fact+1 WHERE IdPersonal = var1;
        UPDATE PersonalClothing SET dateNext= SELECT INTERVAL TimeN MONTH + `date1` FROM `PersonalClothing` WHERE `IdPersonal` = var1;
    ELSE
        INSERT INTO `PersonalClothing`( `Old_IdPersonal`, `IdWorker1`, `IdClothing1`, `quantity`, `comment`, `date1`, `dateNext`, `purchasePrice`, `causeOfDelay`, `dateCause`, `transferCause`) VALUES (SELECT `Old_IdPersonal`, `IdWorker1`, `IdClothing1`, `quantity`, `comment`, `date1`, `dateNext`, `purchasePrice`, `causeOfDelay`, `dateCause`, `transferCause` FROM PersonalClothing WHERE IdPersonal` = var1;);
END IF;
END//