23 lines
647 B
SQL
23 lines
647 B
SQL
DELIMITER $$
|
|
CREATE PROCEDURE insertMenuOptions()
|
|
BEGIN
|
|
DECLARE i INT DEFAULT 0;
|
|
DECLARE var_cafe_menu_id INT;
|
|
DECLARE count_cafe_menu INT;
|
|
|
|
SET count_cafe_menu = (SELECT COUNT(*) FROM `cafe_menu`);
|
|
|
|
WHILE(i < count_cafe_menu) DO
|
|
SET var_cafe_menu_id = (SELECT cafe_menu_id
|
|
FROM `cafe_menu`
|
|
LIMIT i, 1);
|
|
|
|
INSERT IGNORE INTO `menu_option` (title, created_at, created_by, updated_at, updated_by, cafe_menu_id)
|
|
VALUES ('SIZE', now(), 'system', now(), 'system', var_cafe_menu_id);
|
|
|
|
SET i = i + 1;
|
|
END WHILE;
|
|
END$$
|
|
DELIMITER ;
|
|
|
|
CALL insertMenuOptions(); |