• What is define Syntax for store PROCEDURE in mysql?

    What is define Syntax for store PROCEDURE in mysql?

     

    Silver Member Asked on August 10, 2018 in MYSQL.
    Add Comment
  • 1 Answer(s)
    Best answer
    DELIMITER $$
    CREATE
    
    /*[DEFINER = { user | CURRENT_USER }]*/
    
    PROCEDURE `test`.`createlogin`()
    
    /*LANGUAGE SQL
    
    | [NOT] DETERMINISTIC
    
    | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA }
    
    | SQL SECURITY { DEFINER | INVOKER }
    
    | COMMENT 'string'*/
    
    BEGIN
    END$$
    DELIMITER ;
    
    Silver Member Answered on August 10, 2018.
    Add Comment
  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.