为什么要使用数据库? | https://developer.aliyun.com/ask/281174 |
什么是MYSQL? | https://developer.aliyun.com/ask/281175 |
数据库三大范式是什么? | https://developer.aliyun.com/ask/281176 |
mysql有关权限的表都有哪几个? | https://developer.aliyun.com/ask/281177 |
MySQL的binlog有有几种录入格式?分别有什么区别? | https://developer.aliyun.com/ask/281178 |
mysql有哪些数据类型? | https://developer.aliyun.com/ask/281179 |
MySQL存储引擎MyISAM与InnoDB区别? | https://developer.aliyun.com/ask/281180 |
MyISAM与InnoDB区别? | https://developer.aliyun.com/ask/281181 |
MyISAM索引与InnoDB索引的区别? | https://developer.aliyun.com/ask/281182 |
InnoDB引擎的4大特性? | https://developer.aliyun.com/ask/281183 |
如何选择存储引擎? | https://developer.aliyun.com/ask/281184 |
什么是索引? | https://developer.aliyun.com/ask/281185 |
索引有哪些优缺点? | https://developer.aliyun.com/ask/281186 |
索引有哪几种类型? | https://developer.aliyun.com/ask/281187 |
索引的数据结构(b树,hash)? | https://developer.aliyun.com/ask/281188 |
索引的基本原理是什么? | https://developer.aliyun.com/ask/281189 |
索引算法有哪些? | https://developer.aliyun.com/ask/281190 |
索引设计的原则? | https://developer.aliyun.com/ask/281191 |
创建索引的原则(重中之重) | https://developer.aliyun.com/ask/281192 |
创建索引的三种方式,删除索引 | https://developer.aliyun.com/ask/281193 |
创建索引时需要注意什么? | https://developer.aliyun.com/ask/281194 |
使用索引查询一定能提高查询的性能吗?为什么 | https://developer.aliyun.com/ask/281195 |
百万级别或以上的数据如何删除 | https://developer.aliyun.com/ask/281196 |
什么是最左前缀原则?什么是最左匹配原则? | https://developer.aliyun.com/ask/281197 |
B树和B+树的区别? | https://developer.aliyun.com/ask/281198 |
使用B树的好处? | https://developer.aliyun.com/ask/281199 |
使用B+树的好处? | https://developer.aliyun.com/ask/281200 |
Hash索引和B+树所有有什么区别或者说优劣呢? | https://developer.aliyun.com/ask/281201 |
数据库为什么使用B+树而不是B树? | https://developer.aliyun.com/ask/281202 |
B+树在满足聚簇索引和覆盖索引的时候不需要回表查询数据? | https://developer.aliyun.com/ask/281203 |
什么是聚簇索引?何时使用聚簇索引与非聚簇索引? | https://developer.aliyun.com/ask/281205 |
非聚簇索引一定会回表查询吗? | https://developer.aliyun.com/ask/281206 |
联合索引是什么?为什么需要注意联合索引中的顺序? | https://developer.aliyun.com/ask/281207 |
什么是数据库事务? | https://developer.aliyun.com/ask/281208 |
事物的四大特性(ACID)介绍一下? | https://developer.aliyun.com/ask/281209 |
什么是脏读?幻读?不可重复读? | https://developer.aliyun.com/ask/281210 |
什么是事务的隔离级别?MySQL的默认隔离级别是什么? | https://developer.aliyun.com/ask/281211 |
对MySQL的锁了解吗? | https://developer.aliyun.com/ask/281212 |
隔离级别与锁的关系? | https://developer.aliyun.com/ask/281213 |
从锁的类别上分MySQL都有哪些锁呢? | https://developer.aliyun.com/ask/281214 |
MySQL中InnoDB引擎的行锁是怎么实现的? | https://developer.aliyun.com/ask/281215 |
InnoDB存储引擎的锁的算法有三种? | https://developer.aliyun.com/ask/281217 |
什么是死锁?怎么解决? | https://developer.aliyun.com/ask/281219 |
数据库的乐观锁和悲观锁是什么?怎么实现的? | https://developer.aliyun.com/ask/281221 |
为什么要使用视图?什么是视图? | https://developer.aliyun.com/ask/281222 |
视图有哪些特点? | https://developer.aliyun.com/ask/281226 |
视图的使用场景有哪些? | https://developer.aliyun.com/ask/281227 |
视图的优点? | https://developer.aliyun.com/ask/281230 |
视图的缺点? | https://developer.aliyun.com/ask/281232 |
什么是游标? | https://developer.aliyun.com/ask/281236 |
什么是存储过程?有哪些优缺点? | https://developer.aliyun.com/ask/281237 |
什么是触发器?触发器的使用场景有哪些? | https://developer.aliyun.com/ask/281239 |
MySQL中都有哪些触发器? | https://developer.aliyun.com/ask/281240 |
SQL语句主要分为哪几类? | https://developer.aliyun.com/ask/281242 |
超键、候选键、主键、外键分别是什么? | https://developer.aliyun.com/ask/281244 |
SQL 约束有哪几种? | https://developer.aliyun.com/ask/281246 |
子查询的三种情况? | https://developer.aliyun.com/ask/281247 |
mysql中 in 和 exists 区别? | https://developer.aliyun.com/ask/281249 |
varchar与char的区别? | https://developer.aliyun.com/ask/281250 |
varchar(50)中50的涵义? | https://developer.aliyun.com/ask/281251 |
int(20)中20的涵义 | https://developer.aliyun.com/ask/281252 |
mysql中int(10)和char(10)以及varchar(10)的区别 | https://developer.aliyun.com/ask/281255 |
FLOAT和DOUBLE的区别是什么? | https://developer.aliyun.com/ask/281257 |
FLOAT和DOUBLE的区别是什么? | https://developer.aliyun.com/ask/281260 |
UNION与UNION ALL的区别? | https://developer.aliyun.com/ask/281263 |
SQL的生命周期? | https://developer.aliyun.com/ask/281266 |
大表数据查询,怎么优化? | https://developer.aliyun.com/ask/281267 |
关心过业务系统里面的sql耗时吗?对慢查询都怎么优化过? | https://developer.aliyun.com/ask/281269 |
为什么要尽量设定一个主键? | https://developer.aliyun.com/ask/281272 |
主键使用自增ID还是UUID? | https://developer.aliyun.com/ask/281273 |
字段为什么要求定义为not null? | https://developer.aliyun.com/ask/281275 |
如果要存储用户的密码散列,应该使用什么字段进行存储? | https://developer.aliyun.com/ask/281277 |
优化查询过程中的数据访问 | https://developer.aliyun.com/ask/281279 |
优化长难的查询语句 | https://developer.aliyun.com/ask/281281 |
优化特定类型的查询语句 | https://developer.aliyun.com/ask/281282 |
优化关联查询 | https://developer.aliyun.com/ask/281284 |
优化子查询 | https://developer.aliyun.com/ask/281285 |
优化LIMIT分页 | https://developer.aliyun.com/ask/281287 |
优化UNION查询 | https://developer.aliyun.com/ask/281288 |
优化WHERE子句 | https://developer.aliyun.com/ask/281289 |
为什么要优化? | https://developer.aliyun.com/ask/281290 |
数据库结构优化 | https://developer.aliyun.com/ask/281291 |
MySQL数据库cpu飙升到500%的话他怎么处理? | https://developer.aliyun.com/ask/281292 |
大表怎么优化?某个表有近千万数据,CRUD比较慢,如何优化?分库分表了是怎么做的? | https://developer.aliyun.com/ask/281293 |
MySQL的复制原理以及流程? | https://developer.aliyun.com/ask/281294 |
读写分离有哪些解决方案? | https://developer.aliyun.com/ask/281295 |
备份计划,mysqldump以及xtranbackup的实现原理? | https://developer.aliyun.com/ask/281296 |
数据表损坏的修复方式有哪些? | https://developer.aliyun.com/ask/281297 |