qq_21122683的博客

1.postgreSql查看死锁及解决办法： https://blog.csdn.net/liuxiumeitanjie/article/details/38816871 1.检测死锁 例如：SELECT procpid FROM pg_stat_activity WHERE datname=‘数据库ID’ and waiting =‘t’; wating值为t的那条，就是死锁的进程。 2....

1.postgres查询结果导出csv文件 1.1 query.sql: SET client_encoding = 'UTF8'; \c temp; copy (select * from xxx_conf.product where id='1' order by "create_time" desc) to '/tmp/query.csv' (format csv, delimiter ...

更改用户密码 用SET PASSWORD命令 首先登录MySQL。 格式：mysql> set password for 用户名@localhost = password('新密码'); 例子：mysql> set password for root@localhost = password('123'); ...

Jedis操作redis数据库 import redis.clients.jedis.Jedis; public class JedisTest { public static void main(String[] args) { JedisTest ins = new JedisTest(); ins.test1(); } priv...