Code: Select all
DELIMITER $$
DROP PROCEDURE IF EXISTS `myproducts`.`GetProducts` $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `GetProducts`()
BEGIN
SELECT * FROM PRODUCTS;
END $$
DELIMITER ;
Rick.
Code: Select all
DELIMITER $$
DROP PROCEDURE IF EXISTS `myproducts`.`GetProducts` $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `GetProducts`()
BEGIN
SELECT * FROM PRODUCTS;
END $$
DELIMITER ;