--
-- 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:
Post a Comment