模板介绍

模板说明

执行存储过程，将数据输出到日志

流程图

依赖表结构

CREATE TABLE `exclefile`  (
  `id` int NOT NULL,
  `message` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `time` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

储存过程代码

CREATE DEFINER=`root`@`localhost` PROCEDURE `get_exclefile`(IN `input_id` VARCHAR(255))
BEGIN
    SELECT * FROM `exclefile` WHERE `id` = input_id;
END

使用评价