Skip to content

DELIMITER syntax #9

@theking2

Description

@theking2

The MySQL/MariaDB create procedure/function seems not to be supported.

DROP Procedure IF EXISTS `add`;
DELIMITER $$
CREATE /* DEFINER=`minidwh`@`localhost` */ PROCEDURE `add`(IN `a` INT, IN `b` INT, OUT `result` INT)
BEGIN
set result = a + b;
END$$
DELIMITER ;

is formatted as

DROP Procedure IF EXISTS `add`;


DELIMITER $$CREATE
/* DEFINER=`minidwh`@`localhost` */
PROCEDURE `add`(IN `a` INT, IN `b` INT, OUT `result` INT) BEGIN
set
  result = a + b;


END $$DELIMITER;

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions