Friday, 18 April 2008

How to use IF statment in MySQL

--
-- Definition of procedure `sp_location_select`
--

DROP PROCEDURE IF EXISTS `sp_location_select`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER' */ $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_location_select`(

in _ID bigint,
in _Name varchar(50),
in _Description varchar(50)

)
BEGIN

IF (_ID is not null) THEN
Select * From location WHERE ID = _ID;
ELSE
SELECT * From location;
END IF;

END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */ $$

DELIMITER ;

No comments: