<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[KissedBySnow的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/KissedBySnow</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; KissedBySnow]]></copyright><item><title><![CDATA[SpringBoot 报错]]></title><link>https://blog.youkuaiyun.com/KissedBySnow/article/details/147514272</link><guid>https://blog.youkuaiyun.com/KissedBySnow/article/details/147514272</guid><author>KissedBySnow</author><pubDate>Fri, 25 Apr 2025 15:41:18 +0800</pubDate><description><![CDATA[查看最新版本：https://mvnrepository.com/artifact/org.freemarker/freemarker。使用最新的 SpringBoot 框架时遇到报错。]]></description><category></category></item><item><title><![CDATA[Nginx：支持 HTTPS]]></title><link>https://blog.youkuaiyun.com/KissedBySnow/article/details/147426208</link><guid>https://blog.youkuaiyun.com/KissedBySnow/article/details/147426208</guid><author>KissedBySnow</author><pubDate>Tue, 22 Apr 2025 17:11:23 +0800</pubDate><description><![CDATA[www.0ll1.com，也可以是 IP。修改为 http 服务的 url 即可。在下文中，将采用如下定义。]]></description><category></category></item><item><title><![CDATA[Nginx：前后端分离配置（静态资源+反向代理）]]></title><link>https://blog.youkuaiyun.com/KissedBySnow/article/details/147426175</link><guid>https://blog.youkuaiyun.com/KissedBySnow/article/details/147426175</guid><author>KissedBySnow</author><pubDate>Tue, 22 Apr 2025 17:09:48 +0800</pubDate><description><![CDATA[【代码】Nginx：前后端分离配置（静态资源+反向代理）]]></description><category></category></item><item><title><![CDATA[JS：slice 方法：简洁直观，图文并茂，让你轻松掌握！]]></title><link>https://blog.youkuaiyun.com/KissedBySnow/article/details/137690413</link><guid>https://blog.youkuaiyun.com/KissedBySnow/article/details/137690413</guid><author>KissedBySnow</author><pubDate>Fri, 12 Apr 2024 18:18:17 +0800</pubDate><description><![CDATA[快速上手 JavaScript slice 方法，简洁直观，图文并茂，让你轻松掌握！]]></description><category></category></item><item><title><![CDATA[规范：数据操作方式对比及相关单词介绍]]></title><link>https://blog.youkuaiyun.com/KissedBySnow/article/details/137684126</link><guid>https://blog.youkuaiyun.com/KissedBySnow/article/details/137684126</guid><author>KissedBySnow</author><pubDate>Fri, 12 Apr 2024 15:56:53 +0800</pubDate><description><![CDATA[create\add\save\insert\post\put\update\edit\change\modify\search\query\list\find\get\list\select\get\delete\remove\drop\cancel]]></description><category></category></item><item><title><![CDATA[Markdown：Mermaid 流程图换行问题]]></title><link>https://blog.youkuaiyun.com/KissedBySnow/article/details/135403534</link><guid>https://blog.youkuaiyun.com/KissedBySnow/article/details/135403534</guid><author>KissedBySnow</author><pubDate>Fri, 05 Jan 2024 10:30:47 +0800</pubDate><description><![CDATA[n<br><br>]]></description><category></category></item><item><title><![CDATA[Vue3：自定义图标选择器（包含 SVG 图标封装）]]></title><link>https://blog.youkuaiyun.com/KissedBySnow/article/details/134293926</link><guid>https://blog.youkuaiyun.com/KissedBySnow/article/details/134293926</guid><author>KissedBySnow</author><pubDate>Wed, 08 Nov 2023 17:08:36 +0800</pubDate><description><![CDATA[本文参考：https://blog.youkuaiyun.com/houtengyang/article/details/129043100。：我的 svg 存放路径是根目录下的。路径下各个层级的 .svg 文件。将上述使用示例封装为组件。]]></description><category></category></item><item><title><![CDATA[MySQL：在MySQL中实现toStartOfQuarter和toStartOfWeek等函数]]></title><link>https://blog.youkuaiyun.com/KissedBySnow/article/details/132365779</link><guid>https://blog.youkuaiyun.com/KissedBySnow/article/details/132365779</guid><author>KissedBySnow</author><pubDate>Fri, 18 Aug 2023 17:11:45 +0800</pubDate><description><![CDATA[探索在 MySQL 中实现 ClickHouse 的日期函数：toStartOfYear/toStartOfQuarter/toStartOfMonth/toMonday/toStartOfWeek]]></description><category></category></item><item><title><![CDATA[Vue3：刷新当前页面的方式]]></title><link>https://blog.youkuaiyun.com/KissedBySnow/article/details/130270150</link><guid>https://blog.youkuaiyun.com/KissedBySnow/article/details/130270150</guid><author>KissedBySnow</author><pubDate>Thu, 20 Apr 2023 16:38:51 +0800</pubDate><description><![CDATA[Vue3.2 刷新当前页面的方式]]></description><category></category></item><item><title><![CDATA[CSS：Reset【CSS Tools】]]></title><link>https://blog.youkuaiyun.com/KissedBySnow/article/details/129751363</link><guid>https://blog.youkuaiyun.com/KissedBySnow/article/details/129751363</guid><author>KissedBySnow</author><pubDate>Fri, 24 Mar 2023 15:14:59 +0800</pubDate><description><![CDATA[CSS 工具：Resst CSS]]></description><category></category></item><item><title><![CDATA[MySQL：行列转换（行转列、列转行）]]></title><link>https://blog.youkuaiyun.com/KissedBySnow/article/details/129560870</link><guid>https://blog.youkuaiyun.com/KissedBySnow/article/details/129560870</guid><author>KissedBySnow</author><pubDate>Wed, 15 Mar 2023 16:53:57 +0800</pubDate><description><![CDATA[MySQL 行列转换，看这一篇文章就够了！]]></description><category></category></item><item><title><![CDATA[JavaScript：函数与箭头函数的区别]]></title><link>https://blog.youkuaiyun.com/KissedBySnow/article/details/129365270</link><guid>https://blog.youkuaiyun.com/KissedBySnow/article/details/129365270</guid><author>KissedBySnow</author><pubDate>Mon, 06 Mar 2023 16:25:38 +0800</pubDate><description><![CDATA[简单明了，带你了解函数与箭头函数的区别。]]></description><category></category></item><item><title><![CDATA[Win10：系统迁移，重启报错0xc000000e]]></title><link>https://blog.youkuaiyun.com/KissedBySnow/article/details/127227405</link><guid>https://blog.youkuaiyun.com/KissedBySnow/article/details/127227405</guid><author>KissedBySnow</author><pubDate>Sun, 09 Oct 2022 15:18:33 +0800</pubDate><description><![CDATA[进行系统迁移时（使用 DiskGenius），报错：“启动更新参数错误”。
启动时（使用新系统），报错：“0xc000000e”。]]></description><category></category></item><item><title><![CDATA[ClickHouse：排序键如何选择，如何设置索引以加快查询速度？]]></title><link>https://blog.youkuaiyun.com/KissedBySnow/article/details/126105000</link><guid>https://blog.youkuaiyun.com/KissedBySnow/article/details/126105000</guid><author>KissedBySnow</author><pubDate>Mon, 01 Aug 2022 16:58:56 +0800</pubDate><description><![CDATA[问题描述：表常用筛选项有2个订单ID（粒度细）、计划ID。一个计划可包含多个订单，如何设置排序键？]]></description><category></category></item><item><title><![CDATA[MySQL：date+time 转 datetime]]></title><link>https://blog.youkuaiyun.com/KissedBySnow/article/details/123540833</link><guid>https://blog.youkuaiyun.com/KissedBySnow/article/details/123540833</guid><author>KissedBySnow</author><pubDate>Thu, 17 Mar 2022 02:11:33 +0800</pubDate><description><![CDATA[合并 date 与 time 类型，得到 datetime 类型]]></description><category></category></item><item><title><![CDATA[Double 精度损失问题]]></title><link>https://blog.youkuaiyun.com/KissedBySnow/article/details/121929836</link><guid>https://blog.youkuaiyun.com/KissedBySnow/article/details/121929836</guid><author>KissedBySnow</author><pubDate>Tue, 14 Dec 2021 16:13:08 +0800</pubDate><description><![CDATA[Double 精度损失问题
2021年12月14日 朋友给了行代码
SELECT
  CAST(4.2 AS double) / cast(3 AS bigint)

使用 ClickHouse 执行了一下，结果是：
1.4000000000000001

这里出现了精度损失，我们希望的结果是 1.4。如何解决这个问题，找寻答案的过程中看到了一句话：

二进制方式的浮点数表示不是精确的
Reference：https://bbs.youkuaiyun.com/topics/90388247

然后我有了灵感，既然浮点数]]></description><category></category></item><item><title><![CDATA[Mac M1：zsh command not found ll]]></title><link>https://blog.youkuaiyun.com/KissedBySnow/article/details/120987757</link><guid>https://blog.youkuaiyun.com/KissedBySnow/article/details/120987757</guid><author>KissedBySnow</author><pubDate>Wed, 27 Oct 2021 10:28:33 +0800</pubDate><description><![CDATA[zsh: command not found: ll
一、问题分析
系统未给 ls -l 配置别名 ll
二、解决步骤


通过 ~/.zshrc 文件配置别名
echo 'alias ll="ls -l"' &gt;&gt; ~/.zshrc



刷新 ~/.zshrc 文件
source ~/.zshrc




]]></description><category></category></item><item><title><![CDATA[Linux：线上服务 CPU 问题定位]]></title><link>https://blog.youkuaiyun.com/KissedBySnow/article/details/118927571</link><guid>https://blog.youkuaiyun.com/KissedBySnow/article/details/118927571</guid><author>KissedBySnow</author><pubDate>Tue, 20 Jul 2021 09:44:51 +0800</pubDate><description><![CDATA[线上服务 CPU 问题定位

identification /aɪˌdentɪfɪˈkeɪʃn/ n. 鉴定，识别；认同；身份证明
PID(Process Identification) 进程标识符
TID(Thread Identification) 线程标识符

REFERENCE：

https://mp.weixin.qq.com/s/fU4i-jDVHgdJfRtWtXaxrQ



找到最耗 CPU 的进程
top -c # 显示进程运行信息列表

键入 P，进程按照 CPU 使用率排序


找]]></description><category></category></item><item><title><![CDATA[DB：简单实现拉链表；拉链表案例]]></title><link>https://blog.youkuaiyun.com/KissedBySnow/article/details/118890467</link><guid>https://blog.youkuaiyun.com/KissedBySnow/article/details/118890467</guid><author>KissedBySnow</author><pubDate>Mon, 19 Jul 2021 10:40:26 +0800</pubDate><description><![CDATA[拉链表：记录一个事物从开始到当前的状态变化

REFERENCE：

https://blog.youkuaiyun.com/Andy_shenzl/article/details/106230597

一个简单的拉链表，记录了每个用户随着时间的变化其等级的变动情况




user_id
name
level
start_time
end_time




1
田家炳
A
2000-01-01
9999-12-31


2
张国荣
B
2000-01-01
2000-01-02


2
张国荣
A
2000-01-.]]></description><category></category></item><item><title><![CDATA[Linux：文档编辑：grep；grep 命令]]></title><link>https://blog.youkuaiyun.com/KissedBySnow/article/details/118890448</link><guid>https://blog.youkuaiyun.com/KissedBySnow/article/details/118890448</guid><author>KissedBySnow</author><pubDate>Mon, 19 Jul 2021 10:35:14 +0800</pubDate><description><![CDATA[查找文件里符合条件的字符串

REFERENCE：

https://www.runoob.com/linux/linux-comm-grep.html

The Syntax of grep
grep [ -abcEFGhHilLnqrsvVwxy ][ -A&lt;显示行数&gt; ][ -B&lt;显示列数&gt; ][ -C&lt;显示列数&gt; ][ -d&lt;进行动作&gt; ][ -e&lt;范本样式&gt; ][ -f&lt;范本文件&gt; ][ --help ][ 范本样式 ][ .]]></description><category></category></item></channel></rss>