postgresql修改自增序列 ----删除前先解除 id 对该序列的依赖ALTER TABLE tablename ALTER COLUMN id SET DEFAULT null;DROP SEQUENCE IF EXISTS sequence_name;---- id_max 即 id 目前的最大值，可写为1，可通过 “SELECT MAX(id) FROM tablename” 得到CREATE SEQUENCE sequence_name START WITH id_max;ALTER TABLE tablename ALTER COLUMN id SET DEFAULT nextval('sequence_name'::regclass);示例ALTER TABLE bookmarks ALTER COLUMN id SET DEFAULT null;DROP SEQUENCE IF EXISTS bookmarks_id_seqCREATE SEQUENCE bookmarks_id_seq START WITH 42920698;ALTER TABLE bookmarks ALTER COLUMN id SET DEFAULT nextval('bookmarks_id_seq'::regclass);

PHP 正则替换img标签中的width function removeImgAttr($content) { $content = preg_replace( array( '/(<img [^<>]*?)width=.+?[\'|\"]/', '/(<img.*?)((height)=[\'"]+[0-9|%]+[\'"]+)/', '/(<img.*?)((style)=[\'"]+(.*?)+[\'"]+)/', ) , array('$1 width="90%" ', '$1', '$1') , $content); return $content; }

ssh私钥多台电脑共用 配置~/.ssh/config文件ServerAliveInterval 5 Host gitee.com AddKeysToAgent yes IdentityFile /home/jypony/.ssh/gitee_id_rsa Host bitbucket.org AddKeysToAgent yes IdentityFile /home/jypony/.ssh/viu_id_rsa秘钥权限配置chmod 600 id_rsa chmod 644 id_rsa.pub测试是否连接成功ssh -T git@gitee.com

Kubuntu 配置多桌面快捷键 设置快捷键设置->快捷键->全局快捷键->KWin切换上一个桌面: Meta+Ctrl+Left切换下一个桌面: Meta+Ctrl+Right显示桌面网格: Meta+`phpstorm 方法定位快捷键冲突(Ctrl+F12)系统设置->快捷键->全局快捷键->Plasma->显示桌面->调整快捷键为无phpstrom alt多选文字冲突系统设置->窗口管理->窗口行为->窗口操作->修饰键设置->快捷键->全局快捷键->ksmserverksmserver->锁定会话->全局备选快捷键设置为空

sed 匹配日志文件 匹配带有get-list的行并输出sed -n '/get-list/p' ottuser-access.log-20210716 > tmp0.log删除匹配带有user_id in的行sed -i '/user_id in/d' tmp0.log