Category Covered

Basic mysql stored procedure

DELIMITER $$

CREATE

    PROCEDURE `areslog_shanghai`.`albumItems`()

    BEGIN

    END$$

DELIMITER ;

another example
-------------------

DELIMITER $$

USE `areslog_shanghai`$$

DROP PROCEDURE IF EXISTS `albumItems`$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `albumItems`()
    
BEGIN
	SELECT * FROM areslog_shanghai.nite_parties;
   
END$$

DELIMITER ;