MySQL Forums
Forum List  »  Spanish

ERROR EN PROCEDIMIENTO ALMACENADO
Posted by: Eduardo Velazquez
Date: March 08, 2018 02:39PM

Hola buen dia, soy nuevo en esto de mysql, estoy tratando de validar un ingreso de un usuario mediante un procedimiento almacenado, si existe me devulve 1 y si no me devulve 0 mediante php, este es mi store


CREATE PROCEDURE validaingreso (
IN
usr VARCHAR(10),
pwd VARCHAR(10),
OUT
codvalidacion INT)
BEGIN
SELECT * FROM tbl_usuario
WHERE tbl_usuario.correo = usr
and tbl_usuario.contraseña = pwd
END

Options: ReplyQuote


Subject
Views
Written By
Posted
ERROR EN PROCEDIMIENTO ALMACENADO
306
March 08, 2018 02:39PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.