IF EXISTS no Mysql

19Out08

O famoso IF EXISTS agora no Mysql… rsrsrs

CREATE DEFINER=`root`@`localhost` PROCEDURE `teste`()
BEGIN
    IF EXISTS (SELECT 1 FROM usuario) THEN
        select ‘SIM’;
    ELSE
        select ‘NAO’;
    END IF;
END

Filed under: Sql   |  Leave a Comment
Tags: Definer, Exists, If, Mysql, Procedure, Stored