What's wrong in the php admin query

Question

What's wrong in the php admin query

Navigation

#1 by (0 votes)

-1

THE MANAGER IS MYSQL PHP ADMIN, I WANT TO MAKE THIS CONSULTATION WITH PARAMETERS

CREATE PROCEDURE VALIDAR_USUARIO (IN nombre varchar(20), IN contraseña varchar(50) )
BEGIN
SELECT * FROM usuario WHERE usuario.User = nombre AND usuario.Pass= contraseña ;
END

phpmyadmin

asked by Amadeuss96 20.06.2018 в 23:07

source

1 answer

HTML does not recognize CSS Show array in table

score 0 · Answer 1

You should check the documentation of Maria DB here , to create it is done like this, the begin and The end are not recognized commands now.

DELIMITER $$
CREATE DEFINER='root'@'localhost' PROCEDURE 'getlogin'(
    p_usuario VARCHAR(20),
    p_clave VARCHAR(50)
    )
SELECT  id_usuario
    FROM usuario 
    WHERE usuario = p_usuario  
      AND clave = p_clave$$
DELIMITER ;