随笔分类 -  mysql

高级查询
摘要：判断ISFULL(exp1,exp2) //exp1不为null,则返回exp1,否则返回exp2where name IS nullwhere name IS NOT nullwhere binary name = ‘aaa’ //区别大小写=,!=,<>,>,>=查询处理逻辑查询执行顺序每一步生 阅读全文
posted @ 2024-01-15 16:32 wangzhilei 阅读(49) 评论(0) 推荐(0)
InnoDB页存储结构
摘要：![](https://img2024.cnblogs.com/blog/2529613/202401/2529613-20240115155605983-854542227.png) 阅读全文
posted @ 2024-01-15 15:56 wangzhilei 阅读(12) 评论(0) 推荐(0)
InnoDB索引结构
摘要：![](https://img2024.cnblogs.com/blog/2529613/202401/2529613-20240115155409945-353762314.png) 阅读全文
posted @ 2024-01-15 15:55 wangzhilei 阅读(8) 评论(0) 推荐(0)
InnoDB行存储结构
摘要：![](https://img2024.cnblogs.com/blog/2529613/202401/2529613-20240115160230831-993280655.png) 阅读全文
posted @ 2024-01-15 15:53 wangzhilei 阅读(6) 评论(0) 推荐(0)