- 博客(9)
- 收藏
- 关注
RSS订阅原创 clickhouse批量更新
query = "SELECT * FROM school_score_special WHERE spn = '' LIMIT 10000" # 替换为你的表名。query = "SELECT count(*) FROM school_score_special WHERE spn = ''" # 替换为你的表名。password = 'xxxxxxxx' # 替换为你的密码。user = 'xxxxx' # 替换为你的用户名。# 使用正则表达式匹配括号内容并去除。# 数据库用户名和密码。
2024-05-07 09:32:27
281
原创 sqlserver 还原无独占访问权
ALTER DATABASE [ruo-vue-pro] SET OFFLINE WITH ROLLBACK IMMEDIATEALTER DATABASE [ruo-vue-pro] SET ONLINE WITH ROLLBACK IMMEDIATE
2023-07-20 15:06:13
45
原创 php 对接 北向数据接口 socket
function encode($msgType, $timeStamp, $body) {return "\xFF\xFF".pack('CNn', $msgType, $timeStamp, strlen($body)).$body;}$connection->send(encode(1, time(), 'reqLoginAlarm;user=xxx;key=xxx;type=xxx'));
2022-01-04 16:27:05
185
原创 php 网页转pdf
linux 安装wkhtmltopdf下载地址https://wkhtmltopdf.org/downloads.html服务器是centos7wgethttps://github.com/wkhtmltopdf/packaging/releases/download/0.12.6-1/wkhtmltox-0.12.6-1.centos7.x86_64.rpm下载有点慢rpm -ivhwkhtmltox-0.12.6-1.centos7.x86_64.rpm提示缺少xorg...
2021-09-02 14:00:37
116
原创 wget抓取网站, 模拟手机端抓取
nohup wget --mirror -p --tries=100 --convert-links -P . –user-agent="Mozilla/5.0 (iPad; U; CPU OS 3_2 like Mac OS X; en-us) AppleWebKit/531.21.10 (KHTML, like Gecko) Version/4.0.4 Mobile/7B334b Safari/531.21.10" http://网址 >1.log 2>&1 &no..
2021-09-02 11:31:34
238
转载 rtsp 通过 浏览器播放
安装docker ffmpeghttps://blog.csdn.net/m1f2c3/article/details/93624289docker pull jrottenberg/ffmpegdocker run -it --entrypoint='bash' jrottenberg/ffmpegdocker start ...下载jsmpegnpm install -g wsnpm install wsnpm install http-server -g进入jsmp
2021-08-30 16:40:10
428
原创 linux frp 内网穿透 nginx反向代理
wget https://github.com/fatedier/frp/releases/download/v0.20.0/frp_0.20.0_linux_amd64.tar.gzfrps.ini 服务端 有外网IP服务器frpc.ini 客户端 局域网服务器服务端:vi frps.ini[common]bind_port = 8700token = asdasdasdasdasdasdasdvi start_frp_server.shnohup ./frps -.
2021-08-27 16:18:41
633
1
原创 vue引入51la流量监控
main.jsrouter.afterEach( ( to, from, next ) => { setTimeout(()=>{ var _hmt = _hmt || []; (function() { //每次执行前，先移除上次插入的代码 document.getElementById('51_la') && document.getElementById('51_la').remove(); var hm = d
2021-06-23 15:54:37
960
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人