mysql
小刀拉屁股让你开开眼
╮(╯_╰)╭
展开
-
mysql5.7 查最近修改表结构记录
SELECT * FROM information_schema.tables WHERE table_schema = '数据库' and update_time is not null ORDER BY create_time desc原创 2021-09-02 15:20:35 · 1001 阅读 · 0 评论 -
mybatis-plus QueryWrapper 的 and/or 用法
先说结论:一个括号等于一个QueryWrapper例:假设一句sqlselect * from tbl where 1 = 1 (and is_deleted = 0 and ((id = 'id1' and status != 1) or (id = 'id2' and status != 2)))where 1 =1 之后 4个括号,即4个QueryWrapper。实体类:@Data@TableName("tbl")@Accessors(chain = true)public cla原创 2021-07-14 14:58:15 · 1529 阅读 · 0 评论 -
mybatis-plus QueryWrapper自定义排序
把自定义sql拼在orderByAsc()/orderByDesc() 中即可。例: wrapper.orderByAsc(" ( case status when 0 then 0 when 1 then 1 else 999 end ) ");原创 2021-02-23 11:59:38 · 7964 阅读 · 4 评论 -
mysql间歇性失联问题
报错信息为:2020-07-15 15:50:05.749 [Druid-ConnectionPool-Create-408909888] [] [com.alibaba.druid.pool.DruidDataSource] ERROR: create connection SQLException, url: jdbc:mysql://xxx, errorCode 0, state 08S01com.mysql.cj.jdbc.exceptions.CommunicationsException:原创 2020-07-15 17:12:13 · 429 阅读 · 0 评论