<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[honvin的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/hon_vin</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; hon_vin]]></copyright><item><title><![CDATA[costrict-router工具使用]]></title><link>https://blog.youkuaiyun.com/hon_vin/article/details/166142935</link><guid>https://blog.youkuaiyun.com/hon_vin/article/details/166142935</guid><author>hon_vin</author><pubDate>Sun, 20 Sep 2026 23:51:09 +0800</pubDate><description><![CDATA[costrict-hub目前写死了服务地址，如需使用自定义的服务地址，需执行下面的手动登录即可。]]></description><category></category></item><item><title><![CDATA[浏览器开启深色模式]]></title><link>https://blog.youkuaiyun.com/hon_vin/article/details/162040613</link><guid>https://blog.youkuaiyun.com/hon_vin/article/details/162040613</guid><author>hon_vin</author><pubDate>Tue, 16 Jun 2026 16:45:54 +0800</pubDate><description><![CDATA[【代码】浏览器开启深色模式。]]></description><category></category></item><item><title><![CDATA[MySQL生成雪花算法ID]]></title><link>https://blog.youkuaiyun.com/hon_vin/article/details/160879312</link><guid>https://blog.youkuaiyun.com/hon_vin/article/details/160879312</guid><author>hon_vin</author><pubDate>Fri, 08 May 2026 10:45:42 +0800</pubDate><description><![CDATA[摘要：本文展示了SQL实现雪花ID算法的两种方式。第一种直接计算方式通过位运算组合时间戳、机器ID和序列号；第二种创建了可复用的snowflake_id函数，使用CRC32生成机器ID，并处理毫秒级时间戳和序列号递增。两种方法都能生成符合雪花算法规范的64位ID，示例结果为7458326199558728174。函数方式通过参数指定机器标识，更适合生产环境使用。]]></description><category></category></item><item><title><![CDATA[加速访问GitHub的方法]]></title><link>https://blog.youkuaiyun.com/hon_vin/article/details/160008254</link><guid>https://blog.youkuaiyun.com/hon_vin/article/details/160008254</guid><author>hon_vin</author><pubDate>Fri, 10 Apr 2026 09:48:33 +0800</pubDate><description><![CDATA[使用镜像站加速访问GitHub]]></description><category></category></item><item><title><![CDATA[影视文件重命名正则]]></title><link>https://blog.youkuaiyun.com/hon_vin/article/details/156764725</link><guid>https://blog.youkuaiyun.com/hon_vin/article/details/156764725</guid><author>hon_vin</author><pubDate>Fri, 09 Jan 2026 15:13:07 +0800</pubDate><description><![CDATA[该正则表达式用于批量重命名影视文件，提取原文件名中的季号（S01）、集数（E01）和扩展名（mkv），生成&quot;影视名称.S01E01.mkv&quot;格式的新文件名。源表达式匹配各种常见命名格式，新表达式保留关键信息并简化文件名。示例显示它能有效去除分辨率、编码格式等冗余信息，实现标准化命名。]]></description><category></category></item><item><title><![CDATA[docker-compose一键部署Springboot+Vue前后端分离项目]]></title><link>https://blog.youkuaiyun.com/hon_vin/article/details/149907906</link><guid>https://blog.youkuaiyun.com/hon_vin/article/details/149907906</guid><author>hon_vin</author><pubDate>Mon, 04 Aug 2025 16:04:35 +0800</pubDate><description><![CDATA[使用docker-compose部署Springboot+Vue项目，并配置接口访问前缀+一键启动]]></description><category></category></item><item><title><![CDATA[docker部署RustDesk自建服务器]]></title><link>https://blog.youkuaiyun.com/hon_vin/article/details/145806494</link><guid>https://blog.youkuaiyun.com/hon_vin/article/details/145806494</guid><author>hon_vin</author><pubDate>Sun, 23 Feb 2025 12:21:49 +0800</pubDate><description><![CDATA[docker部署RustDesk自建服务器]]></description><category></category></item><item><title><![CDATA[一站式SQL工具箱 | 多字段测试数据生成 | Excel转SQL | 文本拼接 | DDL代码生成]]></title><link>https://blog.youkuaiyun.com/hon_vin/article/details/145316255</link><guid>https://blog.youkuaiyun.com/hon_vin/article/details/145316255</guid><author>hon_vin</author><pubDate>Thu, 23 Jan 2025 09:50:57 +0800</pubDate><description><![CDATA[一站式SQL工具箱 | 多字段测试数据生成 | Excel转SQL | 文本拼接 | DDL代码生成]]></description><category></category></item><item><title><![CDATA[常用文件工具类]]></title><link>https://blog.youkuaiyun.com/hon_vin/article/details/144503976</link><guid>https://blog.youkuaiyun.com/hon_vin/article/details/144503976</guid><author>hon_vin</author><pubDate>Mon, 16 Dec 2024 11:53:34 +0800</pubDate><description><![CDATA[【代码】常用文件工具类。]]></description><category></category></item><item><title><![CDATA[常用List工具类（取交集、并集等等）]]></title><link>https://blog.youkuaiyun.com/hon_vin/article/details/143804673</link><guid>https://blog.youkuaiyun.com/hon_vin/article/details/143804673</guid><author>hon_vin</author><pubDate>Fri, 15 Nov 2024 17:52:53 +0800</pubDate><description><![CDATA[【代码】常用List工具类（取交集、并集等等）]]></description><category></category></item><item><title><![CDATA[cmd快速结束Java进程]]></title><link>https://blog.youkuaiyun.com/hon_vin/article/details/141325679</link><guid>https://blog.youkuaiyun.com/hon_vin/article/details/141325679</guid><author>hon_vin</author><pubDate>Mon, 19 Aug 2024 14:58:27 +0800</pubDate><description><![CDATA[cmd快速结束Java进程]]></description><category></category></item><item><title><![CDATA[将nginx注册为Windows系统服务]]></title><link>https://blog.youkuaiyun.com/hon_vin/article/details/133717846</link><guid>https://blog.youkuaiyun.com/hon_vin/article/details/133717846</guid><author>hon_vin</author><pubDate>Mon, 09 Oct 2023 22:41:10 +0800</pubDate><description><![CDATA[将nginx注册为Windows系统服务]]></description><category></category></item><item><title><![CDATA[nginx运行vue项目的dist文件]]></title><link>https://blog.youkuaiyun.com/hon_vin/article/details/133715425</link><guid>https://blog.youkuaiyun.com/hon_vin/article/details/133715425</guid><author>hon_vin</author><pubDate>Mon, 09 Oct 2023 21:10:58 +0800</pubDate><description><![CDATA[nginx运行vue项目的dist文件，并防止刷新404]]></description><category></category></item><item><title><![CDATA[将本地代码提交到git新仓库]]></title><link>https://blog.youkuaiyun.com/hon_vin/article/details/133699868</link><guid>https://blog.youkuaiyun.com/hon_vin/article/details/133699868</guid><author>hon_vin</author><pubDate>Mon, 09 Oct 2023 13:30:14 +0800</pubDate><description><![CDATA[将本地代码提交到git新仓库]]></description><category></category></item><item><title><![CDATA[MySQL日期时间类型 常用的查询、转换、计算]]></title><link>https://blog.youkuaiyun.com/hon_vin/article/details/128133726</link><guid>https://blog.youkuaiyun.com/hon_vin/article/details/128133726</guid><author>hon_vin</author><pubDate>Thu, 01 Dec 2022 17:02:53 +0800</pubDate><description><![CDATA[【代码】MySQL日期时间常用查询、转换、计算。]]></description><category></category></item><item><title><![CDATA[IDEA - 常用Live Templates]]></title><link>https://blog.youkuaiyun.com/hon_vin/article/details/128101249</link><guid>https://blog.youkuaiyun.com/hon_vin/article/details/128101249</guid><author>hon_vin</author><pubDate>Tue, 29 Nov 2022 16:57:20 +0800</pubDate><description><![CDATA[idea常用Live Templates：注释、定义变量等]]></description><category></category></item><item><title><![CDATA[MySQL学习笔记4：排序规则的修改]]></title><link>https://blog.youkuaiyun.com/hon_vin/article/details/127647032</link><guid>https://blog.youkuaiyun.com/hon_vin/article/details/127647032</guid><author>hon_vin</author><pubDate>Wed, 02 Nov 2022 10:27:00 +0800</pubDate><description><![CDATA[如果没有设置字段级别的字符集和排序规则，那么默认就取表的，如果表上也没有设置那就默认取schema上的字符集和排序规则，一般来说schema上肯定是配置了的（必须要配置，否则会取默认的字符集和排序规则），实例级别的字符集和排序规则一般用不到。如果要修改排序规则，那么至少要把一个表的所有字段和表的排序规则一起修改，否则就是在。一个表的字段用不一样的字符集和排序规则会导致混乱。然后再修改表的排序规则。]]></description><category></category></item><item><title><![CDATA[MySQL学习笔记3：排序规则和排序规则的影响]]></title><link>https://blog.youkuaiyun.com/hon_vin/article/details/127635022</link><guid>https://blog.youkuaiyun.com/hon_vin/article/details/127635022</guid><author>hon_vin</author><pubDate>Tue, 01 Nov 2022 15:45:40 +0800</pubDate><description><![CDATA[在mysql数据库中，排序规则是依赖字符集编码的，他们在mysql中经常是捆绑的存在。排序规则一般指对字符集中字符串之间的比较、排序制定的规则。一种字符集可以对应多种排序规则，但是一种排序规则只能对应指定的一种字符集，两个不同的字符集不能有相同的排序规则上图中utf8mb4字符集对应多个排序规则。每种字符集都有一个默认的排序规则。比如上图中utf8mb4默认的排序规则就是utf8mb4_general_ci。也就是说，]]></description><category></category></item><item><title><![CDATA[MySQL学习笔记2：如何避免数据库乱码]]></title><link>https://blog.youkuaiyun.com/hon_vin/article/details/127546842</link><guid>https://blog.youkuaiyun.com/hon_vin/article/details/127546842</guid><author>hon_vin</author><pubDate>Thu, 27 Oct 2022 10:18:56 +0800</pubDate><description><![CDATA[客户端发送的sql语句编码字符集。它的作用就是告诉mysql服务器，本地客户端采用了什么编码环境。insert into t values(‘吴’);服务器知道这条sql是以character_set_client指定的字符集所编码的,'吴’将被转化为指定的编码格式，比如它的utf8编码为E590B4，最终以0101…发送到server。：服务器将接收到的character_set_client指定编码的sql语句翻译成character_set_connection指定编码的sql。]]></description><category></category></item><item><title><![CDATA[MySQL学习笔记1：MySQL字符集和字符集编码]]></title><link>https://blog.youkuaiyun.com/hon_vin/article/details/127546696</link><guid>https://blog.youkuaiyun.com/hon_vin/article/details/127546696</guid><author>hon_vin</author><pubDate>Thu, 27 Oct 2022 10:13:19 +0800</pubDate><description><![CDATA[可以理解为某些字符组成的一个集合,集合中由哪些字符组成是由制定这个字符集的协会来决定。如大名鼎鼎的ASCII字符集，含有128个字符，就是一个典型的字符集。：将字符集中的字符映射为特定的字节或者字节序列,它表示的是一种规则。通常特定的字符集采用特定的编码方式。即一种字符集对应一种字符编码,如: ASCII、ISO-8859-1、GB2312、GBK都是表示了字符集又表示了对应的字符编码,但是特例,它对应的字符编码有:UTF-8、UTF-16、UTF-32等，mysql中常用的是UTF-8，其他两种不常用。]]></description><category></category></item></channel></rss>