sql+数据库
那个id是什么东西
只想做一条咸鱼,没事晒晒太阳
展开
-
常用sql集合
1.按照年份月份拆分字段,并统计。 SELECT DATE_FORMAT(creat_time,"%Y年%m月") AS dates,COUNT(*) FROM ssoml.mlcp_node GROUP BY DATE_FORMAT(creat_time,"%Y年%m月") ORDER BY DATE_FORMAT(creat_time,"%Y年%m月") DESC ; 如图: ...原创 2018-10-31 11:04:42 · 209 阅读 · 0 评论 -
sql 常见错误
1. 1248 - Every derived table must have its own alias 解决:原创 2018-10-31 13:49:45 · 291 阅读 · 0 评论 -
springboot 操作原生sql,java取数据,jquery取数据
配置文件 datasource: url: jdbc:mysql://localhost:3306/ssoml?useSSL=false&characterEncoding=utf8 username: root password: root driver-class-name: com.mysql.jdbc.Driver jpa: sh...原创 2018-11-02 10:04:59 · 521 阅读 · 0 评论