mysql -u root -p delphinus < delphinus.sql
Enter password:
ERROR 1064 (42000) at line 97917: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3
CREATE DEFINER=`root`@`localhost` PROCEDURE `cont_delete`(IN contid int(5))
BEGIN
DECLARE padre INT(5);
DECLARE orden INT(5);
SELECT cont_showorder, cont_padre INTO orden, padre FROM pa_contenidos where cont_pkcont = contid;
DELETE FROM pa_contenidos WHERE cont_pkcont = contid;
DELETE FROM pa_contenidos WHERE cont_padre = contid;
DELETE FROM pa_usuario_cont WHERE uc_fkcont = contid;
DELETE FROM pa_mod_cont WHERE uc_fkcont = contid;
UPDATE pa_contenidos set cont_showorder = cont_showorder - 1 where cont_padre = padre and cont_showorder > orden;
END;