I have some procedures where parameter names start with: "p _" . Is it possible to change in a unique way and code all the names of all procedures that start with this abbreviation by: "abc _" for example?
Procedure:
CREATE DEFINER = 'root'@'%' PROCEDURE 'postSac'(
IN p_nome VARCHAR(255),
IN p_telefone VARCHAR(15),
IN p_email VARCHAR(100),
IN p_cidade VARCHAR(100),
IN p_estado VARCHAR(2),
IN p_assunto VARCHAR(255),
IN p_mensagem LONGTEXT
)
NOT DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT ''
BEGIN
DECLARE EXIT HANDLER FOR SQLEXCEPTION
BEGIN
SHOW WARNINGS;
#SELECT 0 AS retorno;
ROLLBACK;
END;
START TRANSACTION;
INSERT INTO sac (nome, telefone, email, cidade, estado, assunto, mensagem) VALUES (p_nome, p_telefone, p_email, p_cidade, p_estado, p_assunto, p_mensagem);
END;