clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 1044276 fiddles created (9431 in the last week).

SELECT VERSION();
VERSION()
8.0.19
 hidden batch(es)


DROP PROCEDURE IF EXISTS `Login`; DROP TABLE IF EXISTS `systemusers`; CREATE TABLE IF NOT EXISTS `systemusers` ( `id_SystemUsers` BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, `nameUser` VARCHAR(100), `userStatus` BOOL ); INSERT INTO `systemusers` (`nameUser`, `userStatus`) VALUES ('Ejemplo1', 1), ('Ejemplo2', 1);
 hidden batch(es)


SELECT `id_SystemUsers`, `nameUser` FROM `systemusers`;
id_SystemUsers nameUser
1 Ejemplo1
2 Ejemplo2
 hidden batch(es)


CREATE PROCEDURE `Login`(`NameUser` VARCHAR(100)) BEGIN SELECT `id_SystemUsers` FROM `systemusers` WHERE `nameUser` = `NameUser` AND `userStatus` = 1; END;
 hidden batch(es)


CALL `Login`('Ejemplo1');
id_SystemUsers
1
2
 hidden batch(es)


DROP PROCEDURE IF EXISTS `Login`;
 hidden batch(es)


CREATE PROCEDURE `Login`(`_NameUser` VARCHAR(100)) BEGIN SELECT `id_SystemUsers` FROM `systemusers` WHERE `nameUser` = `_NameUser` AND `userStatus` = 1; END;
 hidden batch(es)


CALL `Login`('Ejemplo1');
id_SystemUsers
1
 hidden batch(es)


DROP PROCEDURE IF EXISTS `Login`;
 hidden batch(es)


CREATE PROCEDURE `Login`(`NameUser` VARCHAR(100)) BEGIN SELECT `id_SystemUsers` FROM `systemusers` WHERE `systemusers`.`nameUser` = `NameUser` AND `systemusers`.`userStatus` = 1; END;
 hidden batch(es)


CALL `Login`('Ejemplo1');
id_SystemUsers
1
 hidden batch(es)