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

12 lines
198 B
MySQL
Raw Permalink Normal View History

DELIMITER $$
2024-08-20 08:06:10 +00:00
CREATE OR REPLACE DEFINER=`vn`@`localhost` PROCEDURE `vn`.`routeSetOk`(
vRouteFk INT)
BEGIN
UPDATE vn.route r
SET r.isOk = 1
WHERE r.id = vRouteFk;
END$$
DELIMITER ;