<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[psy_ing的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/psy_ing</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; psy_ing]]></copyright><item><title><![CDATA[netty学习：基于WebSocket协议开发服务端及客户端，实现双向通信]]></title><link>https://blog.youkuaiyun.com/psy_ing/article/details/120120323</link><guid>https://blog.youkuaiyun.com/psy_ing/article/details/120120323</guid><author>psy_ing</author><pubDate>Sun, 05 Sep 2021 20:41:10 +0800</pubDate><description><![CDATA[学习过程中有参考Redisson和RocketMq对于netty的使用

一、服务端

1、启动类


    @Autowired
    private WebsocketProperties properties;
    @Autowired
    private WebSocketChannelInitializer webSocketChannelInitializer;

    NioEventLoopGroup bossGroup = new NioEventLoopGroup();
 ]]></description><category></category></item><item><title><![CDATA[MySQL实现排序开窗函数]]></title><link>https://blog.youkuaiyun.com/psy_ing/article/details/109149307</link><guid>https://blog.youkuaiyun.com/psy_ing/article/details/109149307</guid><author>psy_ing</author><pubDate>Sun, 18 Oct 2020 20:19:28 +0800</pubDate><description><![CDATA[MySQL8.0之后开始支持开窗函数，对于低版本的MySQL通过复杂一些的方式也能得到同样的效果：
表结构：
CREATE TABLE `class` (
  `student_id` char(4) NOT NULL,
  `class_id` tinyint NOT NULL,
  `score` double(6,0) NOT NULL,
  PRIMARY KEY (`student_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 C]]></description><category></category></item></channel></rss>