salix/db/routines/vn/procedures/zoneGeo_checkName.sql

10 lines
245 B
MySQL
Raw Permalink Normal View History

DELIMITER $$
2024-08-20 08:06:10 +00:00
CREATE OR REPLACE DEFINER=`vn`@`localhost` PROCEDURE `vn`.`zoneGeo_checkName`(vName VARCHAR(255))
BEGIN
IF vName = '' THEN
SIGNAL SQLSTATE '45000'
SET MESSAGE_TEXT = 'Column `name` cannot be empty';
END IF;
END$$
DELIMITER ;