随笔分类 -  MySQL数据库

数据库存储过程之case、while、loop
摘要：![](https://img2020.cnblogs.com/blog/2005725/202006/2005725-20200613174642667-471150360.png) ![](https://img2020.cnblogs.com/blog/2005725/202006/2005725-20200613174644184-1269831203.png) ![](https://i 阅读全文
posted @ 2020-06-13 17:47 lihao_Q 阅读(240) 评论(0) 推荐(0)
数据库存储过程之if
摘要：![](https://img2020.cnblogs.com/blog/2005725/202006/2005725-20200613162114842-1621259664.png) ![](https://img2020.cnblogs.com/blog/2005725/202006/2005725-20200613162116882-456797338.png) ![](https://i 阅读全文
posted @ 2020-06-13 16:22 lihao_Q 阅读(306) 评论(0) 推荐(0)
数据库存储过程基本语法
摘要：![](https://img2020.cnblogs.com/blog/2005725/202006/2005725-20200613152108474-307021330.png) ![](https://img2020.cnblogs.com/blog/2005725/202006/2005725-20200613152110029-926672391.png) ![](https://im 阅读全文
posted @ 2020-06-13 15:21 lihao_Q 阅读(212) 评论(0) 推荐(0)
数据库事务之不可重复读
摘要：![](https://img2020.cnblogs.com/blog/2005725/202006/2005725-20200613122327410-940858427.png) ![](https://img2020.cnblogs.com/blog/2005725/202006/2005725-20200613122329137-1039963418.png) ![](https://i 阅读全文
posted @ 2020-06-13 12:24 lihao_Q 阅读(214) 评论(0) 推荐(0)
数据库事务与脏读
摘要：![](https://img2020.cnblogs.com/blog/2005725/202006/2005725-20200613113256095-755097486.png) ![](https://img2020.cnblogs.com/blog/2005725/202006/2005725-20200613113258604-1081994555.png) ![](https://i 阅读全文
posted @ 2020-06-13 11:33 lihao_Q 阅读(162) 评论(0) 推荐(0)
数据库表设计与视图
摘要：![](https://img2020.cnblogs.com/blog/2005725/202006/2005725-20200611171504738-837631326.png) ![](https://img2020.cnblogs.com/blog/2005725/202006/2005725-20200611171506658-760804329.png) ![](https://im 阅读全文
posted @ 2020-06-11 17:16 lihao_Q 阅读(429) 评论(0) 推荐(0)
联合查询与模糊查询
摘要：![](https://img2020.cnblogs.com/blog/2005725/202006/2005725-20200610155417511-1808893089.png) ![](https://img2020.cnblogs.com/blog/2005725/202006/2005725-20200610155419958-708308864.png) ![](https://i 阅读全文
posted @ 2020-06-10 15:55 lihao_Q 阅读(278) 评论(0) 推荐(0)
多表查询
摘要：![](https://img2020.cnblogs.com/blog/2005725/202006/2005725-20200609153229779-1370862864.png) ![](https://img2020.cnblogs.com/blog/2005725/202006/2005725-20200609153231793-297497868.png) ![](https://i 阅读全文
posted @ 2020-06-09 15:33 lihao_Q 阅读(152) 评论(0) 推荐(0)
分组查询、分页查询与时间格式函数
摘要：![](https://img2020.cnblogs.com/blog/2005725/202006/2005725-20200608150239900-1240092356.png)![](https://img2020.cnblogs.com/blog/2005725/202006/2005725-20200608150242080-181934198.png)![](https://img... 阅读全文
posted @ 2020-06-08 15:03 lihao_Q 阅读(214) 评论(0) 推荐(0)
聚合函数与常用函数
摘要：![](https://img2020.cnblogs.com/blog/2005725/202006/2005725-20200607155339814-712848132.png) ![](https://img2020.cnblogs.com/blog/2005725/202006/2005725-20200607155341338-809481212.png) ![](https://im 阅读全文
posted @ 2020-06-07 15:54 lihao_Q 阅读(160) 评论(0) 推荐(0)
数据库基本操作
摘要：SQL语句中关键字不区分大小写，标识符区分大小写，标识符如果不加双引号，则默认是按大写执行，如果加双引号，则是按原始大小写执行。 **SQL语句书写规范：**所有表名，列名，全部小写；关键字，内置函数名全部大写。 创建一个数据库： //创建一个数据库，库名为dt55 //语法规则：create da 阅读全文
posted @ 2020-06-02 19:01 lihao_Q 阅读(257) 评论(0) 推荐(0)