Skip to content

Instantly share code, notes, and snippets.

View workze's full-sized avatar
🎯
Focusing

Wangguize workze

🎯
Focusing
View GitHub Profile
@workze
workze / java
Last active September 15, 2018 01:07
gist is just for me!
hello world!
@workze
workze / sql2.sql
Last active February 12, 2020 14:07
all about sql
WITH finished AS (
SELECT workpiece_type, current_procedure, procedure_result, 1 AS status
FROM t_mvp_aau_result
WHERE workpiece_id IN (
SELECT workpiece_id
FROM t_mvp_aau_result
WHERE station_id = '1'
ORDER BY starttime DESC
LIMIT 1
)
@workze
workze / sql2.sql
Created February 12, 2020 14:08
sql2
WITH finished AS (
SELECT workpiece_type, current_procedure, procedure_result, 1 AS status
FROM t_mvp_aau_result
WHERE workpiece_id IN (
SELECT workpiece_id
FROM t_mvp_aau_result
WHERE station_id = '1'
ORDER BY starttime DESC
LIMIT 1
)
@workze
workze / python-keyboard.py
Last active March 20, 2020 09:01
python keyboard key
# pip install PyUserInput
from pykeyboard import *
import time
import pyperclip
import datetime
key = PyKeyboard()
i = 0
@workze
workze / linux-date.sh
Last active April 16, 2020 08:15
linux date
#修改日期,将日期设定成2009年5月7日
date -s 2009-05-07
#修改时间,将时间设定成下午8点18分0秒
date -s 20:18:00
hwclock --systohc
@workze
workze / docker-locatime.sh
Created February 14, 2020 05:45
docker 时区 localtime
# 共享主机的localtime
docker run -ti -d --name my-nginx -v /etc/localtime:/etc/localtime:ro docker.io/nginx /bin/bash
# 复制主机的localtime
docker cp /etc/localtime 87986863838b:/etc/
@workze
workze / shell-if.sh
Last active March 18, 2020 03:45
linux shell bash script if
#!/usr/bin/env bash
install() {
echo "hi"
}
if [[ "$1" == "install" || "$1" == "start"]];
then $1;
else
echo -e "Uxc";
@workze
workze / html-framework.html
Created February 15, 2020 13:19
html icon framework
<link rel="shortcut icon" type="image/x-icon" href="favicon.ico">
@workze
workze / code-love.md
Last active February 15, 2020 14:51
代码 表白 code love
i = Boy()
you = Girl()
love = i + you
git push --tag
git pull --tag
git tag -d v1
打标签
git tag v1
git tag v2 commit-id
查看所有标签