Stored procedure with Declare and Set phpmyadmin

0

I try to do a stored procedure by declaring a variable that stores a data, but apparently I have an error.

Procedure:

create procedure insertarempleado (
  cedula varchar(10),
  pass varchar(15),
  nombre varchar(30),
  apellido varchar(30),
  direccion varchar(30),
  telefono varchar(10),
  correo varchar(30),
  perfildesc varchar(30)
) 

DECLARE id int;

set id = (SELECT idperfil from perfil where perfildesc=descripcion);

INSERT INTO empleado (
  cedulaE,
  PassE,
  nombreE,
  apellidoE,
  direccionE,
  telefonoE,
  correoE,
  idperfil
) VALUES (
  cedula,
  pass,
  nombre,
  apellido,
  direccion,
  telefono,
  correo,
  id
);

Error:

MySQL has said:

#1064 - Algo está equivocado en su sintax cerca 'DECLARE id int' en la linea 2
    
asked by Jeamphier Carriel Roca 09.07.2018 в 05:30
source

0 answers