[MySQL] Stored Procedures in die DB per SQL-Script?

[mkinzler]

Versuchs mal so:

SQL-Code:

DELIMITER $$ ;

DROP PROCEDURE IF EXISTS `deletelizenz' $$
CREATE PROCEDURE `deletelizenz`(INID INT(6))
BEGIN
    DELETE FROM pim_pb_liz WHERE id=INID;
    DELETE FROM pim_pb_liz_fl WHERE lizid=INID;
    DELETE FROM pim_pb_liz_zr WHERE lizid=INID;
END; $$

DELIMITER ; $$