postgre
摘要：删除数据库：dropdb -h 172.31.3.79 -p 5432 -U postgres zcy_test while read line; do echo $line cmd="SELECT pg_terminate_backend($line);" psql -h 172.31.3.79
阅读全文
posted @ 2018-03-23 13:08
随笔分类 - 数据库
oplog
摘要：参考资料：https://www.cnblogs.com/ruizhang3/p/6539730.html http://www.jb51.net/article/113432.htm :insert Raw data {u'h': 0L, u'ts': Timestamp(1519780847,
阅读全文
posted @ 2018-02-28 10:38
《MYSQL必知必会2
摘要：select top distinct column_name from tbl where id>0 group by name having count(*)>10 order by dtime desc age asc limit 1 60、NULL是没有值，空串是一个有效值61、主键只能使用
阅读全文
posted @ 2017-05-07 15:56
