just a quick question, on phpmyadmin this wors perfectly
INSERT into cuerpoacademico
(campus,unAcademica,clave,ano,des,nombreLider,paterno,materno,grado,nombramiento,desde,hasta)
VALUES
(Campus,UnAcademica,Clave,Ano,Des,NombreLider,Materno,Paterno,Grado,Nombramiento,Desde,Hasta)
but, not this:
INSERT into cuerpoacademico
(campus,unAcademica,clave,ano,des,nombreLider,paterno,materno,grado,nombramiento,desde,hasta)
VALUES
(Campus,UnAcademica,Clave,Ano,Des,NombreLider,Materno,Paterno,Grado,Nombramiento,Desde,Hasta);
SET out_param = LAST_INSERT_ID();
The only difference between the two statements is that i added the set line with the function, but it's telling me that i have a syntax error, and if i try to use individually, they work, but in the same procedure, they don't, any help will be greatly apretiated.
