<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[0xadf7Dc19D52eD986AB6c8727D76fcd7C7ce1435b]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/CheersToLife</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; CheersToLife]]></copyright><item><title><![CDATA[如何将表中存储的 JSON 数据转换为新表]]></title><link>https://blog.youkuaiyun.com/CheersToLife/article/details/144270379</link><guid>https://blog.youkuaiyun.com/CheersToLife/article/details/144270379</guid><author>CheersToLife</author><pubDate>Thu, 05 Dec 2024 16:46:12 +0800</pubDate><description><![CDATA[通过上述步骤，我们可以将log_table表中的param_json字段中的 JSON 数组展开为多行，并提取出具体的字段值，然后将其插入到新表new_table中。这使得数据处理更加灵活和方便。]]></description><category></category></item><item><title><![CDATA[VX公众号爬虫-文章图片全下载]]></title><link>https://blog.youkuaiyun.com/CheersToLife/article/details/140441360</link><guid>https://blog.youkuaiyun.com/CheersToLife/article/details/140441360</guid><author>CheersToLife</author><pubDate>Mon, 15 Jul 2024 16:01:13 +0800</pubDate><description><![CDATA[【代码】VX公众号爬虫-文章图片全下载。]]></description><category></category></item><item><title><![CDATA[instr()函数用法]]></title><link>https://blog.youkuaiyun.com/CheersToLife/article/details/132087570</link><guid>https://blog.youkuaiyun.com/CheersToLife/article/details/132087570</guid><author>CheersToLife</author><pubDate>Thu, 03 Aug 2023 16:57:45 +0800</pubDate><description><![CDATA[实验得出，在一个2亿多条记录的表中，同时8个并行，使用like查询很久都不出来结果，但使用instr,4分钟即完成查找，性能是相当的好。由此可得，ORACLE内建的一些函数，是经过相当程度的优化的。instr(name,‘张三’)=0  相当于  name not like ‘%张三%’instr(name,‘张三’)>0  相当于  name like ‘%张三%’instr(name,‘张三’)=1  相当于  name like ‘张三%’]]></description><category></category></item><item><title><![CDATA[pgsql 删除任意重复行]]></title><link>https://blog.youkuaiyun.com/CheersToLife/article/details/129859282</link><guid>https://blog.youkuaiyun.com/CheersToLife/article/details/129859282</guid><author>CheersToLife</author><pubDate>Thu, 30 Mar 2023 15:45:29 +0800</pubDate><description><![CDATA[【代码】pgsql 删除任意重复行。]]></description><category></category></item><item><title><![CDATA[SpringBean的生命周期]]></title><link>https://blog.youkuaiyun.com/CheersToLife/article/details/129527082</link><guid>https://blog.youkuaiyun.com/CheersToLife/article/details/129527082</guid><author>CheersToLife</author><pubDate>Tue, 14 Mar 2023 14:35:46 +0800</pubDate><description><![CDATA[6 springbean实例化之后,就开始注入属性,比如标注@autoware的属性,再调用各种aware接口扩展方法,注入属性,比如beanaNameAware.setName,设置bean的id或者name。2 加载之后,spring容器会对这些bean进行封装,封装成beandefinition对象,就是普通的java对象上再封装一层,赋予spring框架需要用到的属性,比如是否单例,是否懒加载。8 此时已完成bean的初始化,在程序中就可以通过spring容器拿到这些初始化后的bean。]]></description><category></category></item><item><title><![CDATA[CachingOperationNameGenerator]]></title><link>https://blog.youkuaiyun.com/CheersToLife/article/details/129436449</link><guid>https://blog.youkuaiyun.com/CheersToLife/article/details/129436449</guid><author>CheersToLife</author><pubDate>Fri, 10 Mar 2023 09:50:36 +0800</pubDate><description><![CDATA[在controller上加了@RequestMapping注解后,在方法上mapping注解,必须是POST或GET,不然后启动项目的时候就会出现。第一种解决: 方法上的mapping注解指定请求类型,即可!相同类中定义的方法名称一致(比如controller类)今天启动项目的时候发现控制台打印了很多方法名。第二种解决: 修改方法名称。]]></description><category></category></item><item><title><![CDATA[RunScriptError: Run “C:\Windows\system32\cmd.exe /d /s /c node-gyp rebuild“]]></title><link>https://blog.youkuaiyun.com/CheersToLife/article/details/126632376</link><guid>https://blog.youkuaiyun.com/CheersToLife/article/details/126632376</guid><author>CheersToLife</author><pubDate>Wed, 31 Aug 2022 21:19:58 +0800</pubDate><description><![CDATA[在对vue项目进行cnpm i时，报错：RunScriptError: Run “C:\Windows\system32\cmd.exe /d /s /c node-gyp rebuild”此时删除node-modules，在项目目录下，重新打开cmd，执行cnpm i，安装成功。为node-gyp配置安装python2.7以及VC++ build Tools依赖。我查看到关键词是“node-gyp"，于是我以系统管理员身份，打开cmd，python配置环境变量。...]]></description><category></category></item><item><title><![CDATA[GitHub 指令]]></title><link>https://blog.youkuaiyun.com/CheersToLife/article/details/126028957</link><guid>https://blog.youkuaiyun.com/CheersToLife/article/details/126028957</guid><author>CheersToLife</author><pubDate>Thu, 28 Jul 2022 10:14:56 +0800</pubDate><description><![CDATA[无]]></description><category></category></item><item><title><![CDATA[mysql5.7数据导入脚本]]></title><link>https://blog.youkuaiyun.com/CheersToLife/article/details/125824441</link><guid>https://blog.youkuaiyun.com/CheersToLife/article/details/125824441</guid><author>CheersToLife</author><pubDate>Sat, 16 Jul 2022 20:15:08 +0800</pubDate><description><![CDATA[mysql5.7脚本。]]></description><category></category></item><item><title><![CDATA[electron小记]]></title><link>https://blog.youkuaiyun.com/CheersToLife/article/details/123695116</link><guid>https://blog.youkuaiyun.com/CheersToLife/article/details/123695116</guid><author>CheersToLife</author><pubDate>Sat, 16 Jul 2022 19:57:59 +0800</pubDate><description><![CDATA[为自己做个记录，以免忘记！
运行条件：win10+.net 4.5及以上+powershell 3.0(因为使用win10系统，即可在cmd管理员权限下操作，win7系统运行不成功，至今未找到解决方案。)
1.安装好node.js,并更换为淘宝镜像（因为npm是国外源，安装较慢）
2.新建文件夹，随意命名，格式为：【其中需要建立页面（我的默认显示页面为login.html）、main.js和package.json三类文件】
注：其中的main.js和package可以找其他教程复制，我在以下文章也会贴出，]]></description><category></category></item><item><title><![CDATA[pgsql数据库报错:because it does not have a replica identity and publishes updates]]></title><link>https://blog.youkuaiyun.com/CheersToLife/article/details/123518833</link><guid>https://blog.youkuaiyun.com/CheersToLife/article/details/123518833</guid><author>CheersToLife</author><pubDate>Wed, 16 Mar 2022 09:51:21 +0800</pubDate><description><![CDATA[报错信息:
SQL 错误 [55000]: ERROR: cannot delete from table "xxxxx" because it does not have a replica identity and publishes updates
Hint: To enable updating from the table, set REPLICA IDENTITY using ALTER TABLE.
 
 
SQL 错误 [55000]: ERROR: cannot delete from .]]></description><category></category></item><item><title><![CDATA[pgsql 实现oracle的start with与层级树level]]></title><link>https://blog.youkuaiyun.com/CheersToLife/article/details/121970666</link><guid>https://blog.youkuaiyun.com/CheersToLife/article/details/121970666</guid><author>CheersToLife</author><pubDate>Thu, 16 Dec 2021 11:24:50 +0800</pubDate><description><![CDATA[oracle
   			 SELECT LEVEL AS LVL,
                          TPL.PORT_ID,
                          TPL.PARENT_PORTID
              FROM TN_PONLINK TPL
              START WITH TPL.DEV_ID = 'F62A1470D64111E6990CAC577F000001'
              CONNECT BY PRIOR ]]></description><category></category></item><item><title><![CDATA[pgsql 列转行]]></title><link>https://blog.youkuaiyun.com/CheersToLife/article/details/121852909</link><guid>https://blog.youkuaiyun.com/CheersToLife/article/details/121852909</guid><author>CheersToLife</author><pubDate>Fri, 10 Dec 2021 14:22:25 +0800</pubDate><description><![CDATA[1单表查询结果出来只有一行结果
select * from table;


2现在将查询结果由列转为行展示
select unnest(string_to_array(concat_ws(',',a.t_dev_names,a.t_dev_ids,a.T_PORT_NAMES,a.T_PORT_IDS),',')) as result from table as a


步骤分析:
concat_ws:将几个字段合并为一个字段并用逗号拼接成字符串
select concat_ws(',',a.t_dev_]]></description><category></category></item><item><title><![CDATA[nacos在Windows环境下运行cmd控制台显示中文乱码解决]]></title><link>https://blog.youkuaiyun.com/CheersToLife/article/details/116116854</link><guid>https://blog.youkuaiyun.com/CheersToLife/article/details/116116854</guid><author>CheersToLife</author><pubDate>Sun, 25 Apr 2021 09:35:08 +0800</pubDate><description><![CDATA[1. 原因
引起中文乱码的原因是nacos的编码格式默认是UTF-8，而Windows的默认编码格式是GBK，二者冲突导致中文乱码。
2. 解决方法
在nacos的安装目录下，找到\nacos\conf文件夹下的nacos-logback.xml文件，修改其中的编码格式。
    &lt;appender name="CONSOLE" class="ch.qos.logback.core.ConsoleAppender"&gt;
        &lt;encoder&gt;
            &lt]]></description><category></category></item><item><title><![CDATA[设置RHEL(RedHat Enterprise Linux)6命令行界面的分辨率]]></title><link>https://blog.youkuaiyun.com/CheersToLife/article/details/112987341</link><guid>https://blog.youkuaiyun.com/CheersToLife/article/details/112987341</guid><author>CheersToLife</author><pubDate>Fri, 22 Jan 2021 16:03:21 +0800</pubDate><description><![CDATA[修改 /boot/grub/grub.conf，在baikernel 后加上 vga=ask
重启后会提du示选择显示模式：

比如想选择800x600x32的显示模式，输入uzhi车即可
如果以后都想使用此模式，修改/boot/grub/grub.conf，

将kernel后的vga=ask改为vga=0x343

...]]></description><category></category></item><item><title><![CDATA[RHEL(RedHat Enterprise Linux)5/6 ISO 镜像]]></title><link>https://blog.youkuaiyun.com/CheersToLife/article/details/112978087</link><guid>https://blog.youkuaiyun.com/CheersToLife/article/details/112978087</guid><author>CheersToLife</author><pubDate>Fri, 22 Jan 2021 09:59:33 +0800</pubDate><description><![CDATA[本文贴出了 RHEL(RedHat Enterprise Linux) 发行版本中常用的服务器版本的 ISO 镜像文件，供大家下载学习使用，贴出的版本有 RedHat Enterprise Linux(RHEL)5.4/5.5/5.8/6.0/6.3 ISO 镜像文件下载地址：
RHEL 5.4 ISO 下载
http://rhel.ieesee.net/uingei/rhel-server-5.4-i386-dvd.iso
http://rhel.ieesee.net/uingei/rhel-server]]></description><category></category></item><item><title><![CDATA[mysql实现oracle的connect By一行转多行功能]]></title><link>https://blog.youkuaiyun.com/CheersToLife/article/details/108888620</link><guid>https://blog.youkuaiyun.com/CheersToLife/article/details/108888620</guid><author>CheersToLife</author><pubDate>Wed, 30 Sep 2020 17:39:37 +0800</pubDate><description><![CDATA[在项目中将oracle数据库变更为mysql数据库的时候,在储存过程中遇见了connect by与regexp_substr这个关键字,作用是将一行参数转为多行参数

  select regexp_substr('1,2,3,4,5', '[^,]+', 1, rownum) lzh
        from dual
      connect by rownum &lt;= length(regexp_replace('1,2,3,4,5', '[^,]+'));


现在要将之改为mysql数据库,]]></description><category></category></item><item><title><![CDATA[mysql使用mysql.help_topic表实现一行转多行功能]]></title><link>https://blog.youkuaiyun.com/CheersToLife/article/details/108888577</link><guid>https://blog.youkuaiyun.com/CheersToLife/article/details/108888577</guid><author>CheersToLife</author><pubDate>Wed, 30 Sep 2020 17:34:15 +0800</pubDate><description><![CDATA[使用到数据库自带的mysql.help_topic表来属性拆分，help_topic表就是实现行转列功能
SELECT
	SUBSTRING_INDEX(
		SUBSTRING_INDEX('1,2,3,4,5',',',help_topic_id + 1),',' ,- 1) lzh
FROM
	mysql.help_topic
WHERE
	help_topic_id &lt; (LENGTH('1,2,3,4,5')) - LENGTH(REPLACE ('1,2,3,4,5', ',', ''))]]></description><category></category></item><item><title><![CDATA[前端页面变灰]]></title><link>https://blog.youkuaiyun.com/CheersToLife/article/details/105319457</link><guid>https://blog.youkuaiyun.com/CheersToLife/article/details/105319457</guid><author>CheersToLife</author><pubDate>Sat, 04 Apr 2020 22:52:14 +0800</pubDate><description><![CDATA[html {
    -webkit-filter: grayscale(100%);
    filter: grayscale(100%);
}



]]></description><category></category></item><item><title><![CDATA[weblogic12c控制台密码重置]]></title><link>https://blog.youkuaiyun.com/CheersToLife/article/details/105278467</link><guid>https://blog.youkuaiyun.com/CheersToLife/article/details/105278467</guid><author>CheersToLife</author><pubDate>Thu, 02 Apr 2020 21:03:34 +0800</pubDate><description><![CDATA[本来在console里面的安全领域-myrealm-用户和组-weblogic-口令里面设置新密码 ,以为就修改成功了 ,万万没想到,kill掉之后重启应用就启动不起来了
然后就报security之类的错
具体操作如下
1 先杀掉进程
ps -ef|grep java 


Kill -9 41169


2 找到DefaultAuthenticatorInit.ldift文件
可以先备份起来
c...]]></description><category></category></item></channel></rss>