Aqui les dejo lo que muestra
21:42:14 CREATE PROCEDURE salarios_procedure(OUT nomb varchar, OUT apell VARCHAR,OUT depar VARCHAR) BEGIN SELECT e.Nombre INTO nomb, e.Apellido INTO apell , nomDepartamento INTO depar FROM cargoxempleado ca INNER JOIN empleados e ON ca.codEmpleado = e.codEmpleado INNER JOIN departamentos d ON d.codDepartamento = ca.codDepartamento WHERE salario > 2000000; END Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' OUT apell VARCHAR,OUT depar VARCHAR) BEGIN SELECT e.Nombre INTO nomb, e.Apelli' at line 1 0,000 sec
y
21:42:14 DELIMITER; Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER' at line 1 0,000 sec
Código MySQL:
Ver original