<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[月上千秋河]]></title><description><![CDATA[静风流云之挥意舒达—残贱]]></description><link>https://blog.youkuaiyun.com/rox</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; rox]]></copyright><item><title><![CDATA[MySQL升级8.4重启后Host blocked问题的解决]]></title><link>https://blog.youkuaiyun.com/rox/article/details/144550371</link><guid>https://blog.youkuaiyun.com/rox/article/details/144550371</guid><author>rox</author><pubDate>Wed, 18 Dec 2024 10:17:18 +0800</pubDate><description><![CDATA[mysql从8.0升级到了8.4，重启后应用提示Host blocked问题的解决]]></description><category></category></item><item><title><![CDATA[nginx统一端口发布minio的9000和9001]]></title><link>https://blog.youkuaiyun.com/rox/article/details/143449210</link><guid>https://blog.youkuaiyun.com/rox/article/details/143449210</guid><author>rox</author><pubDate>Sat, 02 Nov 2024 12:52:37 +0800</pubDate><description><![CDATA[nginx统一端口发布minio的9000和9001]]></description><category></category></item><item><title><![CDATA[Windows奇葩脚本持续更新]]></title><link>https://blog.youkuaiyun.com/rox/article/details/142976614</link><guid>https://blog.youkuaiyun.com/rox/article/details/142976614</guid><author>rox</author><pubDate>Wed, 16 Oct 2024 11:38:38 +0800</pubDate><description><![CDATA[一些常用的奇葩脚本]]></description><category></category></item><item><title><![CDATA[MySQL8手机号和收件地址校验]]></title><link>https://blog.youkuaiyun.com/rox/article/details/139668833</link><guid>https://blog.youkuaiyun.com/rox/article/details/139668833</guid><author>rox</author><pubDate>Fri, 14 Jun 2024 08:59:37 +0800</pubDate><description><![CDATA[mysql8，使用正则函数REGEXP_REPLACE，过滤临时收件信息]]></description><category></category></item><item><title><![CDATA[MySQL用SQL生成雪花ID]]></title><link>https://blog.youkuaiyun.com/rox/article/details/134921510</link><guid>https://blog.youkuaiyun.com/rox/article/details/134921510</guid><author>rox</author><pubDate>Mon, 11 Dec 2023 11:35:00 +0800</pubDate><description><![CDATA[MySQL用SQL生成伪雪花ID]]></description><category></category></item><item><title><![CDATA[多行文本奇偶行合并]]></title><link>https://blog.youkuaiyun.com/rox/article/details/133841057</link><guid>https://blog.youkuaiyun.com/rox/article/details/133841057</guid><author>rox</author><pubDate>Sun, 15 Oct 2023 12:47:41 +0800</pubDate><description><![CDATA[文本编辑器正则表达式]]></description><category></category></item><item><title><![CDATA[MySQL快速生成日期维度表]]></title><link>https://blog.youkuaiyun.com/rox/article/details/131347952</link><guid>https://blog.youkuaiyun.com/rox/article/details/131347952</guid><author>rox</author><pubDate>Fri, 23 Jun 2023 10:19:32 +0800</pubDate><description><![CDATA[mysql 日期 维度]]></description><category></category></item><item><title><![CDATA[定时备份数据库导出到 Minio]]></title><link>https://blog.youkuaiyun.com/rox/article/details/128545781</link><guid>https://blog.youkuaiyun.com/rox/article/details/128545781</guid><author>rox</author><pubDate>Wed, 04 Jan 2023 11:52:10 +0800</pubDate><description><![CDATA[将数据库备份自动上传到专用的Minio服务]]></description><category></category></item><item><title><![CDATA[MySQL8计划任务]]></title><link>https://blog.youkuaiyun.com/rox/article/details/122648479</link><guid>https://blog.youkuaiyun.com/rox/article/details/122648479</guid><author>rox</author><pubDate>Sun, 23 Jan 2022 10:55:53 +0800</pubDate><description><![CDATA[文章目录准备是否开启任务创建调整禁用激活删除查看历史和参考links
准备
是否开启
select @@event_scheduler;
-- ON

show variables like 'event_scheduler';





Variable_name
Value




event_scheduler
ON


任务
创建
-- DROP EVENT IF EXISTS sync_mtrols_hourly;
CREATE
    DEFINER=`test`@`localhost`
   ]]></description><category></category></item><item><title><![CDATA[MySQL行列转换及多选字典]]></title><link>https://blog.youkuaiyun.com/rox/article/details/112771424</link><guid>https://blog.youkuaiyun.com/rox/article/details/112771424</guid><author>rox</author><pubDate>Mon, 18 Jan 2021 12:11:48 +0800</pubDate><description><![CDATA[文章目录数据准备建表写入数据查询验证第1步：逗号分割 - 列转行SQLRESULT第2步：逗号分割 - 列转行 - 字典匹配SQLRESULT第3步：逗号分割 - 列转行 - 字典匹配 - 分组合并(行转列)SQLRESULT第4步：逗号分割 - 列转行 - 字典匹配 - 分组合并(行转列) - 其他表SQLRESULT参考Links
数据准备
建表

-- 学生表
-- DROP TABLE tb_stu;
CREATE TABLE tb_stu (
  id int(11) NOT NULL AUTO_]]></description><category></category></item><item><title><![CDATA[PLSQL Developer常用配置说明(带图)]]></title><link>https://blog.youkuaiyun.com/rox/article/details/109610370</link><guid>https://blog.youkuaiyun.com/rox/article/details/109610370</guid><author>rox</author><pubDate>Wed, 11 Nov 2020 00:33:56 +0800</pubDate><description><![CDATA[文章目录显示配置My objects升到最顶Tables升到最顶数据库连接配置登出默认事物回滚检查连接保存登录信息查询配置语句自动选择语句执行热键(可选)格式配置关键字自动大写显示配置数字类型 - 字符串格式显示日期类型V1 - 字符串格式显示日期类型V2 - 字符串格式显示（自定义）去掉Date用to_char转换的勾选自定义日期格式SQL Windows List显示保持上次打开的SQL脚本显示文件完整路径
显示配置
My objects升到最顶

Tools→User Interface→Object]]></description><category></category></item><item><title><![CDATA[Oracle SQL Developer 启动参数配置]]></title><link>https://blog.youkuaiyun.com/rox/article/details/109610296</link><guid>https://blog.youkuaiyun.com/rox/article/details/109610296</guid><author>rox</author><pubDate>Wed, 11 Nov 2020 00:18:45 +0800</pubDate><description><![CDATA[文章目录配置文件sqldeveloper.confsqldeveloper-nondebug.conf参数说明IPV4支持英文界面历史和参考
配置文件
sqldeveloper.conf

sqldeveloper.exe的实际配置文件为：…\sqldeveloper\bin\sqldeveloper.conf

......

IncludeConfFile  java11.conf
IncludeConfFile  sqldeveloper-nondebug.conf

sqldeveloper-non]]></description><category></category></item><item><title><![CDATA[CentOS8下MySQL8的安装(在线版)]]></title><link>https://blog.youkuaiyun.com/rox/article/details/109610223</link><guid>https://blog.youkuaiyun.com/rox/article/details/109610223</guid><author>rox</author><pubDate>Wed, 11 Nov 2020 00:17:03 +0800</pubDate><description><![CDATA[文章目录MySQL安装移除旧版下载MySQL安装MySQL修改my.cnf启动MySQL服务更新root密码并新建用户root本地账户dba本地账户dba远程账户
MySQL安装
移除旧版

检查系统已安装的MySQL/MariaDB

rpm -qa |grep mysql
rpm -qa |grep mariadb


移除已安装的mariadb组件

rpm -ev --nodeps mariadb-libs

下载MySQL
cd /tmp
wget https://cdn.mysql.com//D]]></description><category></category></item><item><title><![CDATA[常用Linux命令收集整理]]></title><link>https://blog.youkuaiyun.com/rox/article/details/109600962</link><guid>https://blog.youkuaiyun.com/rox/article/details/109600962</guid><author>rox</author><pubDate>Tue, 10 Nov 2020 16:05:17 +0800</pubDate><description><![CDATA[文章目录系统查看redhat版本查看系统启动参数修改系统启动参数修改后即时生效同步系统时间修改系统时间查看cpu信息查看系统IO瓶颈查看目录下各自磁盘占用空间rpm安装、卸载、列表和查询mysql安装网络查询80端口被哪些程序占用查看8100端口的访问统计编辑iptables修改网卡IP，并重启工具tar打包和解压查看tomcat日志文件的最后200行修改当前默认语言删除/data/projects/myproject/目录（及其子目录下）的所有.svn目录安装和卸载U盘
系统
查看redhat版本
cat]]></description><category></category></item><item><title><![CDATA[SQL Developer、Navicat Premium、PLSQL Developer 通过 Oracle Instant Client 连接]]></title><link>https://blog.youkuaiyun.com/rox/article/details/81173886</link><guid>https://blog.youkuaiyun.com/rox/article/details/81173886</guid><author>rox</author><pubDate>Mon, 23 Jul 2018 20:29:48 +0800</pubDate><description><![CDATA[目录

工具准备

Oracle Instant Client

SQL Developer

配置

Windows System

Oracle Instant Client

SQL Developer

PLSQL Developer

Navicat Premium

工具准备



Oracle Instant Client



http://www.oracle.com/techn...]]></description><category></category></item><item><title><![CDATA[《计模式之禅》试评]]></title><link>https://blog.youkuaiyun.com/rox/article/details/6495816</link><guid>https://blog.youkuaiyun.com/rox/article/details/6495816</guid><author>rox</author><pubDate>Mon, 10 May 2010 13:49:00 +0800</pubDate><description><![CDATA[]]></description><category></category></item></channel></rss>