All pastes #967924 Raw Edit

Mine

public text v1 · immutable
·published 2008-04-02 18:55 UTC
rendered paste body
 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;