汇总：5. 数据库相关_alterdata注册码-CSDN博客

本文链接：https://blog.csdn.net/amen_wu/article/details/79522954

安装和使用

数据库：## 标题 ##

数据库常见面试题汇总（50）
https://blog.csdn.net/weinierzui/article/details/71054964
数据库4大特性
http://blog.csdn.net/wolenski/article/details/7980521
事务传播机制
http://blog.sina.com.cn/s/blog_6689cae30101cpa1.html
数据库5大约束
https://www.2cto.com/database/201304/199872.html
mysql流程控制等语句
http://blog.csdn.net/baoliangsheng/article/details/46459471
JOIN IN与IN的区别
http://blog.csdn.net/qq_33290787/article/details/51931261
Constraints
http://blog.csdn.net/lengyue_wy/article/details/6712258
mysql乐观锁、悲观锁及隔离级别
http://blog.csdn.net/zztfj/article/details/6319740
http://blog.csdn.net/liyantianmin/article/details/50752102
http://blog.csdn.net/fg2006/article/details/6937413
mysql悲观锁
http://chenzhou123520.iteye.com/blog/1860954
mysql乐观锁
http://chenzhou123520.iteye.com/blog/1863407
mybatis乐观锁实现，解决并发问题
https://www.cnblogs.com/linjiqin/p/5096206.html
SQL语句、Mysql、Navicat编码不一致问题
http://blog.csdn.net/fenfei12138/article/details/49661879
复合主键与联合主键
http://blog.csdn.net/amen_wu/article/details/79376605
主键索引和唯一索引的区别
https://www.cnblogs.com/-619569179/p/6528896.html
MySQL的lock tables和unlock tables的用法（转载）
http://blog.csdn.net/amen_wu/article/details/79478529
解决mysql执行SQL文件，报错：”Got a packet bigger than ‘max_allowed_packet’ bytes“
https://blog.csdn.net/github_39325328/article/details/79549756

mysql update和case语句结合
https://blog.csdn.net/qq_25067905/article/details/54948625
mysql中You can’t specify target table for update in FROM clause错误
https://blog.csdn.net/priestmoon/article/details/8016121
mysql中where+if判断
https://blog.csdn.net/zqtsx/article/details/9786453
MySQL多表连接查询
https://www.cnblogs.com/geaozhang/p/6753190.html
mysql 的 case when then 用法和null 的判断
https://www.cnblogs.com/blogxiao/p/7600964.html
MySQL最常用分组聚合函数
https://www.cnblogs.com/geaozhang/p/6745147.html

SQL语句优化（语法+处理逻辑）
http://database.51cto.com/art/200904/118526.htm
http://blog.csdn.net/love_xsq/article/details/42417917
http://www.cnblogs.com/shiluoliming/p/6604407.html

数据库分库分表策略的具体实现方案
http://blog.csdn.net/xlgen157387/article/details/53976153
MyBatis实现Mysql数据库分库分表操作和总结（推荐）
http://www.jb51.net/article/121743.htm?utm_source=debugrun&utm_medium=referral
MySQL分库分表总结
http://blog.csdn.net/hanghangaidoudou/article/details/69569625
Mysql分库分表方案
https://www.cnblogs.com/try-better-tomorrow/p/4987620.html
mysql分表的3种方法
https://www.cnblogs.com/lucky-man/p/6207873.html
MySQL 高可用：mysql+mycat实现数据库分片（分库分表）
http://blog.csdn.net/kk185800961/article/details/51147029
mysql分库分表的常见策略
https://www.2cto.com/database/201708/668574.html
透明的分库分表方案
https://my.oschina.net/tinyframework/blog/531444
Mysql分表和分区的区别、分库分表介绍与区别
https://www.cnblogs.com/langtianya/p/4997768.html
mysql 分库分表
http://songfeng-123.iteye.com/blog/2369504
数据库（分库分表）中间件对比
https://www.cnblogs.com/wangzhongqiu/p/7100332.html
MyCat是什么？为什么要用MyCat？
http://blog.csdn.net/nxw_tsp/article/details/56277430
数据库学习：高并发数据库设计
https://blog.csdn.net/chenpeng19910926/article/details/51789934

主键、约束和索引
https://www.cnblogs.com/Uest/p/5230130.html
什么是数据库索引有哪些类型和特点
https://www.jb51.net/article/73255.htm
漫谈数据库索引
https://kb.cnblogs.com/page/45712/
mysql联合索引
https://www.cnblogs.com/softidea/p/5977860.html
复合索引如何用？创建、使用、排序优化
https://blog.csdn.net/bigtree_3721/article/details/51255401
CREATE INDEX 语句
https://blog.csdn.net/zhanglei5415/article/details/2407681
聚合索引(clustered index) / 非聚合索引(nonclustered index)
https://blog.csdn.net/ak913/article/details/8026743
sql-索引的作用(超详细)
https://www.cnblogs.com/hyd1213126/p/5828937.html
mysql-覆盖索引
https://www.cnblogs.com/happyflyingpig/p/7662881.html