其他
快快乐乐#
这个作者很懒,什么都没留下…
展开
-
将pem证书转换为crt和key
1.pem转crt格式openssl x509 -in fullchain.pem -out fullchain.crt具体用法为:cd ..opensslx509 -in /etc/letsencrypt/archive/domain/fullchain1.pem -out /etc/letsencrypt/archive/domain/fullchain1.crt然后在这个路径找到转换好的证书/etc/letsencrypt/archive/domain2.pem转key格式op原创 2021-11-08 16:18:26 · 3417 阅读 · 0 评论 -
powerDesigner的建表语句默认设置为去掉双引号
powerDesigner的建表语句默认设置为去掉双引号,依次执行如下操作:Database ------>> Edit Current DBMS ------>> Script ------>> sql ------>> Format ------>> CaseSensitivityUsingQuote------>>选择NO...原创 2021-03-23 17:00:54 · 371 阅读 · 0 评论 -
mongodb修改语句
-- 修改语句db.getCollection('T_UserUndoStatus').find({"content":"您有一呼百应消息", "delete" : false,"todoStatus" : "undo"}).forEach(function(item){print("_id"+item._id+",content:"+item.content+",account:"+item.account+",todoStatus:"+item.todoStatus)//db.getCo原创 2021-03-01 08:29:45 · 1017 阅读 · 0 评论 -
死锁查看
SELECT object_name, machine, s.sid, s.serial#FROM gv$locked_object l, dba_objects o, gv$session sWHERE l.object_id = o.object_idAND l.session_id = s.sid and object_name='SYS_IDENTITY';alter system kill session '12, 31331';select * from sys_identi原创 2021-02-28 19:50:48 · 207 阅读 · 0 评论 -
idea数据库自动生产实体类
import com.intellij.database.model.DasTableimport com.intellij.database.util.Caseimport com.intellij.database.util.DasUtil/** Available context bindings:* SELECTION Iterable<DasObject>* PROJECT project* FILES fil...原创 2021-02-28 19:46:18 · 305 阅读 · 0 评论 -
excel字符串连接
设置公式="update WxUser set projectId='"&R2&"',projectName='"&Q2&"' where userType =3 and userid='"&F2&"' and openId='"&G2&"';"原创 2021-02-28 19:44:10 · 206 阅读 · 0 评论 -
nginx配置vue项目
user nginx;worker_processes auto;error_log /var/log/nginx/error.log warn;pid /var/run/nginx.pid;load_module /usr/lib/nginx/modules/ngx_http_naxsi_module.so;worker_rlimit_nofile 65535;events { worker_connections 20480;}http { i...原创 2021-02-28 19:42:30 · 326 阅读 · 0 评论