Тема: помогите пожалуйста 1304!!!
Ошибка
SQL-запрос:
CREATE PROCEDURE `addForbid` ( IN userid1 INTEGER, IN type1 INTEGER, IN forbid_time1 INTEGER, IN reason1 BINARY( 255 ) , IN gmroleid1 INTEGER ) BEGIN DECLARE rowcount INTEGER;
START TRANSACTION;
UPDATE forbid SET ctime = now( ) ,
forbid_time = forbid_time1,
reason = reason1,
gmroleid = gmroleid1 WHERE userid = userid1 AND TYPE = type1;
SET rowcount = ROW_COUNT( ) ;
IF rowcount =0 THEN INSERT INTO forbid
VALUES (
userid1, type1, now( ) , forbid_time1, reason1, gmroleid
);
END IF ;
COMMIT ;
END$$
Ответ MySQL: Документация
#1304 - PROCEDURE addForbid already exists