SELECT
id,
JSON_UNQUOTE(
JSON_EXTRACT(
business_tags,
CONCAT('$[', help_topic.help_topic_id, ']')
)
) AS tag_name
FROM
tag
JOIN mysql.help_topic ON help_topic.help_topic_id < JSON_LENGTH(business_tags)
WHERE
JSON_VALID(business_tags)
AND JSON_LENGTH(business_tags);主要使用的高级用法为mysql.help_topic
这是一个用来生成序列的好东西
# 管理员权限运行powershell
# 设定kms服务器
slmgr /skms 192.168.100.2
# 激活 这步要稍等点时间
slmgr /ato
# 查看过期时间
slmgr /xpr
cd "C:\Program Files\Microsoft Office\Office16"
cscript ospp.vbs /sethst:192.168.100.2
cscript ospp.vbs /actcurl -fsSL https://get.docker.com | bash -s docker --mirror Aliyun
markdown写作还是要比wordpress好不少的，特别是wordpress自带的块复制出来的标签，实在是令人头疼，迁移难度巨大，markdown的语法简单易懂，还便于迁移，能在多个平台上使用，兼容Typora。
# 下载nginx源码
wget http://nginx.org/download/nginx-1.18.0.tar.gz
# 下载nginx-rtmp模块
git clone https://github.com/arut/nginx-rtmp-module.git
# 安装一些以来
apt install gcc make openssl libssl-dev libpcre3 libpcre3-dev zlib1g-dev
# 解包nginx
tar -zxvf nginx-1.18.0.tar.gz
cd nginx-1.18.0/
./configure --prefix=/usr/local/nginx --add-module=../nginx-rtmp-module --with-http_ssl_module
make && make install
cp -r /root/nginx-rtmp-module/ /usr/local/nginx/nginx-rtmp-module
mkdir hls# 阿里镜像
npm config set registry https://registry.npmmirror.com/
# 默认源
npm config set registry https://registry.npmjs.org/
# 阿里镜像
yarn config set registry https://registry.npmmirror.com/
# 默认源
yarn config set registry https://registry.npmjs.org/参考链接：
https://npmmirror.com/