<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[moijsda的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/moijsda</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; moijsda]]></copyright><item><title><![CDATA[Kettle设置Windows定时执行任务脚本]]></title><link>https://blog.youkuaiyun.com/moijsda/article/details/121163394</link><guid>https://blog.youkuaiyun.com/moijsda/article/details/121163394</guid><author>moijsda</author><pubDate>Fri, 05 Nov 2021 15:17:47 +0800</pubDate><description><![CDATA[提示：文章写完后，目录可以自动生成，如何生成可参考右边的帮助文档

文章目录前言一、编写.bat脚本文件二、配置Windows任务计划1.打开任务计划程序2.右击创建任务3.配置

前言
在Windows中如何设置kettle Job的定时任务？
一、编写.bat脚本文件
@echo off
if "%1" == "h" goto begin
mshta vbscript:createobject("wscript.shell").run("%~nx0 h",0)(window.close)&amp;&am]]></description><category></category></item><item><title><![CDATA[数据库递归查询sql语句]]></title><link>https://blog.youkuaiyun.com/moijsda/article/details/121162902</link><guid>https://blog.youkuaiyun.com/moijsda/article/details/121162902</guid><author>moijsda</author><pubDate>Fri, 05 Nov 2021 15:00:48 +0800</pubDate><description><![CDATA[数据库递归查询sql语句mysql数据库sqlserver数据库ORACLE数据库
mysql数据库
建表语句：

CREATE TABLE `menu`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '菜单id',
  `parent_id` int(11) NULL DEFAULT NULL COMMENT '父节点id',
  `menu_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_gene]]></description><category></category></item></channel></rss>