uzip不支持超过4G的文件解压,需要安装7za,7za解压需要处理编码,否则乱码
yum install -y p7zip
# 解压命令,-r递归文件夹,-o指定解压目录,无空格
7za x xxx.zip -r -o/tmp/
# 解决乱码
yum install convmv
# LANG=C表示以US-ASCII这样的编码输出文件名
LANG=C 7za x xxx.zip
# 将解压后的文件进行递归转码
convmv -f GBK -t utf8 --notest -r ./xxx
-- 多个with
with t1(c1,c2) as (select c1, c2 from table),
t2(c1,c2) as (select c1, c2 from table)
select * from t1,t2;
-- 当做变量
with t1(c1, c2) as (values('a','b'),('a','b')),
select * from t1;
docker ps [-a]
docker exec -it ${imageName}|${id} /bin/bash
docker run -it -d --name ${alias} ${imageName}[:$Tag] -p $serverPort:$dockerServerPort /bin/bash
docker cp ${id}:/mnt/mydir/ ./localDir
docker history --format --no-trunc=true ${id} |sed "s?/bin/sh\ -c\ \#(nop)\ ??g"|sed "s?/bin/sh\ -c?RUN?g" | tac
https://github.com/GitSquared/edex-ui
brew install libpq
ln -s /usr/local/Cellar/libpq/xxxxxx/bin/psql /usr/local/bin/psql
psql -h 172.0.0.1 -p 5432 -U postgres -d public
©2025 老鼠扛刀满街找猫.
ICP证：浙ICP备17026237号-1
浙公网安备 33010402004062号
Powered by Jekyll,
theme by Scott Emmons
under Creative Commons Attribution