
数据库
~时光易逝~
过去的每段时光都值得回忆,时光易逝,珍惜当下................
展开
-
postgresql数据库设计文档导出
获取字段名、类型、注释、是否为空:SELECT col_description(a.attrelid,a.attnum) as comment,format_type(a.atttypid,a.atttypmod) as type,a.attname as name, a.attnotnull as notnull FROM pg_class as c,pg_attribute as a where c.relname = '表名' and a.attrelid = c.oid and a.attn..翻译 2021-06-15 16:38:35 · 774 阅读 · 0 评论 -
Windows redis 允许远程
redis.windows.conf配置文件的配置1.注释掉本地绑定2.关闭redis保护模式3.在命令行中输入以下命令:.\redis-server.exe .\Credis.windows.conf原创 2021-04-19 12:39:29 · 227 阅读 · 0 评论 -
hibernate save数据的时候报错:ids for this class must be manually assigned before calling save()
保存数据的时候出错了,看一下主要是由于你的原创 2014-05-08 12:26:49 · 903 阅读 · 0 评论 -
按照每天、每月、每年统计数据
select DATE_FORMAT(create_time,'%Y%u') weeks,count(caseid) count from tc_case group by weeks;select DATE_FORMAT(create_time,'%Y%m%d') days,count(caseid) count from tc_case group by days;select DATE_原创 2014-06-24 16:28:03 · 833 阅读 · 0 评论