-- 多个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
#查看CPU信息（型号）
[root@ecsnode-no ~]# cat /proc/cpuinfo | grep name | cut -f2 -d: | uniq -c
16 Intel Core Processor (Skylake)
# 查看物理CPU个数
[root@ecsnode-no ~]# cat /proc/cpuinfo | grep "physical id" | sort | uniq | wc -l
1
# 查看每个物理CPU中core的个数(即核数)
[root@ecsnode-no ~]# cat /proc/cpuinfo | grep "cpu cores" | uniq
cpu cores : 8
# 查看逻辑CPU的个数
[root@ecsnode-no ~]# cat /proc/cpuinfo | grep "processor" | wc -l
16
©2025 老鼠扛刀满街找猫.
ICP证：浙ICP备17026237号-1
浙公网安备 33010402004062号
Powered by Jekyll,
theme by Scott Emmons
under Creative Commons Attribution