![](https://img-blog.csdnimg.cn/20201014180756928.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
数据库
数据库知识学习
Kira R@bbit
倘若我穿过鸟居,能否遇见神明?
展开
-
include refid ="base_column_list" 详解
include refid =“base_column_list” 详解mybatis 之数据库 include refid ="base_column_list"详解。用来封装SQL语句, 来调用,如果用了refid="base_column_list"则:1、首先定义一个sql标签,一定要定义唯一id字段名1,字段名22、然后通过id引用<select id="selectAl...原创 2019-12-29 23:22:53 · 10247 阅读 · 4 评论 -
mysql分时段查询
```sql#查询今天24小时 (按小时段) SELECT * FROM tableName where TO_DAYS(create_time) = TO_DAYS(NOW()) GROUP BY DATE_FORMAT(create_time,'%H'); ##查询昨天24小时(按小时段) S...原创 2019-11-17 21:42:49 · 329 阅读 · 0 评论