4.4 SQL汇总
## SQL题
参考https://zhuanlan.zhihu.com/p/61805956
https://blog.csdn.net/liyue071714118/article/details/106798833
## mysql 安装 删除 使用
参考https://www.cnblogs.com/Michael1/p/5806384.html
https://www.cnblogs.com/startRuning/p/9628951.html
https://www.cnblogs.com/kumata/p/9125564.html
## cmd启动mysql:mysql -u root -p
## mysql 增加create_time字段,注意格式datetime和timestamp的区别
参考https://www.cnblogs.com/levia/p/11367993.html
https://www.cnblogs.com/acm-bingzi/p/mysql-current-timestamp.html
## Windows下安装MySQL
参考https://www.cnblogs.com/yunlongaimeng/p/12558638.html
## sql设置一个字段为空(null)
参考https://blog.csdn.net/Leo_01169/article/details/88826565
## 使用node查询MySQL数据库时,日期格式不对的问题
参考https://blog.csdn.net/chanlingmai5374/article/details/93190983
## sql与nosql对比
参考https://blog.csdn.net/weixin_43751710/article/details/104964319
## 递归CTE基本用法
https://blog.csdn.net/SKY_02/article/details/82721556
## sql经典面试50题
参考https://blog.csdn.net/weixin_44747933/article/details/106324269
## sql中的窗口函数:lead,lag
参考https://blog.csdn.net/qq_41081716/article/details/108865011
## 生成连续数字
https://www.jianshu.com/p/3dab54dcee99
## 报错: this is incompatible with sql_mode=only_full_group_by
参考https://blog.csdn.net/qq_42175986/article/details/82384160
## mysql8 新增用户
参考https://blog.51cto.com/abcd/2481013
## mysql8 创建、删除用户和授权、消权操作
参考https://blog.csdn.net/weixin_35067439/article/details/113159734
## 本地电脑连接阿里云服务器上搭建的MySQL数据库
参考https://ac-fun.blog.csdn.net/article/details/106968143
## mysql自动更新时间
https://blog.csdn.net/myth8860/article/details/116453236
## mysql主键是否一定自增
https://blog.csdn.net/hollis_chuang/article/details/125383101
## 主键约束与唯一约束区别
https://blog.csdn.net/qq_37115780/article/details/100668568
## with和create view的区别
https://blog.csdn.net/Robin_Pi/article/details/123185262
## left join多个表
https://learnsql.com/blog/how-to-left-join-multiple-tables/
https://stackoverflow.com/questions/36135436/multiple-left-joins-what-is-the-left-table
## 关联子查询
https://blog.csdn.net/WuLex/article/details/111188587
https://blog.csdn.net/liu_feng_zi_/article/details/106819482
## 内连接、外连接、交叉连接
https://blog.csdn.net/qq_42606136/article/details/120325032
## 创建及增删改查
https://www.jianshu.com/p/db57844594a1
## 自动添加创建时间、更新时间
https://blog.csdn.net/A1924/article/details/117074646
## full outer join
https://www.runoob.com/sql/sql-join-full.html
## nvl函数
https://blog.csdn.net/qq_38603049/article/details/109678312
## case when
https://zhuanlan.zhihu.com/p/356135200
## 外键检查Cannot delete or update a parent row: a foreign key constraint fails
https://blog.csdn.net/CSDN9825/article/details/112197803
## 导出数据
https://www.runoob.com/mysql/mysql-database-export.html
https://blog.csdn.net/carefree2005/article/details/113762170
# Hive
## 表结构增删改查
https://blog.csdn.net/m0_52184330/article/details/121183634
https://blog.csdn.net/u011495642/article/details/83831347
https://blog.csdn.net/midailaoqi/article/details/121035326
## extraneous input ';' expecting EOF
https://blog.csdn.net/xieganyu3460/article/details/83055935
## 层次结构
https://blog.csdn.net/l_dsj/article/details/121501723
# 底层原理
## b+tree是单向链表还是双向链表
https://blog.csdn.net/weixin_43155866/article/details/108791358
posted on 2022-04-07 22:36 Hiteration 阅读(25) 评论(0) 编辑 收藏 举报