postgresql 删除重复数据 方法一 普通方法DELETE FROM bookmarks A WHERE A.ID NOT IN ( SELECT MIN ( ID ) FROM bookmarks GROUP BY "user_id", "product_id", "is_from_vuclip" );方法二 速度快DELETE FROM bookmarks A WHERE A.ID = ANY ( ARRAY ( SELECT ID FROM ( SELECT ROW_NUMBER ( ) OVER ( PARTITION BY "user_id", "product_id", "is_from_vuclip" ), ID FROM bookmarks ) T WHERE T.ROW_NUMBER > 1 ) );

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->锁定会话->全局备选快捷键设置为空