René's URL Explorer Experiment

Title: JavaInterview/interviewDoc/Java/database/MySQL.md at master · lalala2527/JavaInterview · GitHub

Open Graph Title: JavaInterview/interviewDoc/Java/database/MySQL.md at master · lalala2527/JavaInterview

X Title: JavaInterview/interviewDoc/Java/database/MySQL.md at master · lalala2527/JavaInterview

Description: Java面试整理，涵盖基础、JVM、线程并发、框架、MySQL、微服务、Redis、中间件、数据结构与算法等。陆续完善中 - JavaInterview/interviewDoc/Java/database/MySQL.md at master · lalala2527/JavaInterview

Open Graph Description: Java面试整理，涵盖基础、JVM、线程并发、框架、MySQL、微服务、Redis、中间件、数据结构与算法等。陆续完善中 - lalala2527/JavaInterview

X Description: Java面试整理，涵盖基础、JVM、线程并发、框架、MySQL、微服务、Redis、中间件、数据结构与算法等。陆续完善中 - lalala2527/JavaInterview

Opengraph URL: https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md

X: @github

direct link

Domain: github.com

route-pattern	/:user_id/:repository/blob/name(/path)
route-controller	blob
route-action	show
fetch-nonce	v2:6d9c4b9e-60b5-1cc4-355a-e3a5ab97d402
current-catalog-service-hash	f3abb0cc802f3d7b95fc8762b94bdcb13bf39634c40c357301c4aa1d67a256fb
request-id	C088:90EFB:264EADC:370172B:6A58F72F
html-safe-nonce	47934e5e8c9c2c18f814fa85beaadb0d74f0a54fb8b86c3f336286aad1e5fedd
visitor-payload	eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJDMDg4OjkwRUZCOjI2NEVBREM6MzcwMTcyQjo2QTU4RjcyRiIsInZpc2l0b3JfaWQiOiIyNTg4Nzg5NTgwOTQzMTI4MzY3IiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0=
visitor-hmac	6d89aadf7eaadc3eed74f93d112b608fa2e3577694274fbf89bfa8b815f41e50
hovercard-subject-tag	repository:740957798
github-keyboard-shortcuts	repository,source-code,file-tree,copilot
google-site-verification	Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-url	https://collector.github.com/github/collect
analytics-location	///blob/show
fb:app_id	1401488693436528
apple-itunes-app	app-id=1477376905, app-argument=https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md
twitter:image	https://opengraph.githubassets.com/2e0778b07f85d5a66c02990703c20b5a05f88196070c269a62a7e423648f5f00/lalala2527/JavaInterview
twitter:card	summary_large_image
og:image	https://opengraph.githubassets.com/2e0778b07f85d5a66c02990703c20b5a05f88196070c269a62a7e423648f5f00/lalala2527/JavaInterview
og:image:alt	Java面试整理，涵盖基础、JVM、线程并发、框架、MySQL、微服务、Redis、中间件、数据结构与算法等。陆续完善中 - lalala2527/JavaInterview
og:image:width	1200
og:image:height	600
og:site_name	GitHub
og:type	object
hostname	github.com
expected-hostname	github.com
None	5f2a0c7865178af3d91dd9f13b0cdfc3c73a2529c873d2780bb4c01271a57ec6
turbo-cache-control	no-cache
go-import	github.com/lalala2527/JavaInterview git https://github.com/lalala2527/JavaInterview.git
octolytics-dimension-user_id	77928217
octolytics-dimension-user_login	lalala2527
octolytics-dimension-repository_id	740957798
octolytics-dimension-repository_nwo	lalala2527/JavaInterview
octolytics-dimension-repository_public	true
octolytics-dimension-repository_is_fork	true
octolytics-dimension-repository_parent_id	245599072
octolytics-dimension-repository_parent_nwo	gsjqwyl/JavaInterview
octolytics-dimension-repository_network_root_id	245599072
octolytics-dimension-repository_network_root_nwo	gsjqwyl/JavaInterview
turbo-body-classes	logged-out env-production page-responsive
disable-turbo	false
browser-stats-url	https://api.github.com/_private/browser/stats
browser-errors-url	https://api.github.com/_private/browser/errors
release	8aae7b8d6caacacf5c66eaeb2702d8dc88d85b4a
ui-target	full
theme-color	#1e2327
color-scheme	light dark

Links:

Skip to content	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#start-of-content
	https://github.com/
Sign in	https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Flalala2527%2FJavaInterview%2Fblob%2Fmaster%2FinterviewDoc%2FJava%2Fdatabase%2FMySQL.md
GitHub CopilotWrite better code with AI	https://github.com/features/copilot
GitHub Copilot appDirect agents from issue to merge	https://github.com/features/ai/github-app
MCP RegistryNewIntegrate external tools	https://github.com/mcp
ActionsAutomate any workflow	https://github.com/features/actions
CodespacesInstant dev environments	https://github.com/features/codespaces
IssuesPlan and track work	https://github.com/features/issues
Code ReviewManage code changes	https://github.com/features/code-review
GitHub Advanced SecurityFind and fix vulnerabilities	https://github.com/security/advanced-security
Code securitySecure your code as you build	https://github.com/security/advanced-security/code-security
Secret protectionStop leaks before they start	https://github.com/security/advanced-security/secret-protection
Why GitHub	https://github.com/why-github
Documentation	https://docs.github.com
Blog	https://github.blog
Changelog	https://github.blog/changelog
Marketplace	https://github.com/marketplace
View all features	https://github.com/features
Enterprises	https://github.com/enterprise
Small and medium teams	https://github.com/team
Startups	https://github.com/enterprise/startups
Nonprofits	https://github.com/solutions/industry/nonprofits
App Modernization	https://github.com/solutions/use-case/app-modernization
DevSecOps	https://github.com/solutions/use-case/devsecops
DevOps	https://github.com/solutions/use-case/devops
CI/CD	https://github.com/solutions/use-case/ci-cd
View all use cases	https://github.com/solutions/use-case
Healthcare	https://github.com/solutions/industry/healthcare
Financial services	https://github.com/solutions/industry/financial-services
Manufacturing	https://github.com/solutions/industry/manufacturing
Government	https://github.com/solutions/industry/government
View all industries	https://github.com/solutions/industry
View all solutions	https://github.com/solutions
AI	https://github.com/resources/articles?topic=ai
Software Development	https://github.com/resources/articles?topic=software-development
DevOps	https://github.com/resources/articles?topic=devops
Security	https://github.com/resources/articles?topic=security
View all topics	https://github.com/resources/articles
Customer stories	https://github.com/customer-stories
Events & webinars	https://github.com/resources/events
Ebooks & reports	https://github.com/resources/whitepapers
Business insights	https://github.com/solutions/executive-insights
GitHub Skills	https://skills.github.com
Documentation	https://docs.github.com
Customer support	https://support.github.com
Community forum	https://github.com/orgs/community/discussions
Trust center	https://github.com/trust-center
Partners	https://github.com/partners
View all resources	https://github.com/resources
GitHub SponsorsFund open source developers	https://github.com/open-source/sponsors
Security Lab	https://securitylab.github.com
Maintainer Community	https://maintainers.github.com
Accelerator	https://github.com/open-source/accelerator
GitHub Stars	https://stars.github.com
Archive Program	https://archiveprogram.github.com
Topics	https://github.com/topics
Trending	https://github.com/trending
Collections	https://github.com/collections
Enterprise platformAI-powered developer platform	https://github.com/enterprise
GitHub Advanced SecurityEnterprise-grade security features	https://github.com/security/advanced-security
Copilot for BusinessEnterprise-grade AI features	https://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 support	https://github.com/enterprise/premium-support
Pricing	https://github.com/pricing
Search syntax tips	https://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
documentation	https://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
Sign in	https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Flalala2527%2FJavaInterview%2Fblob%2Fmaster%2FinterviewDoc%2FJava%2Fdatabase%2FMySQL.md
Sign up	https://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fblob%2Fshow&source=header-repo&source_repo=lalala2527%2FJavaInterview
Reload	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md
Reload	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md
Reload	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md
lalala2527	https://github.com/lalala2527
JavaInterview	https://github.com/lalala2527/JavaInterview
gsjqwyl/JavaInterview	https://github.com/gsjqwyl/JavaInterview
Notifications	https://github.com/login?return_to=%2Flalala2527%2FJavaInterview
Fork 0	https://github.com/login?return_to=%2Flalala2527%2FJavaInterview
Star 0	https://github.com/login?return_to=%2Flalala2527%2FJavaInterview
Code	https://github.com/lalala2527/JavaInterview
Pull requests 0	https://github.com/lalala2527/JavaInterview/pulls
Actions	https://github.com/lalala2527/JavaInterview/actions
Projects	https://github.com/lalala2527/JavaInterview/projects
Security and quality 0	https://github.com/lalala2527/JavaInterview/security
Insights	https://github.com/lalala2527/JavaInterview/pulse
Code	https://github.com/lalala2527/JavaInterview
Pull requests	https://github.com/lalala2527/JavaInterview/pulls
Actions	https://github.com/lalala2527/JavaInterview/actions
Projects	https://github.com/lalala2527/JavaInterview/projects
Security and quality	https://github.com/lalala2527/JavaInterview/security
Insights	https://github.com/lalala2527/JavaInterview/pulse
	https://github.com/lalala2527/JavaInterview
JavaInterview	https://github.com/lalala2527/JavaInterview/tree/master
interviewDoc	https://github.com/lalala2527/JavaInterview/tree/master/interviewDoc
Java	https://github.com/lalala2527/JavaInterview/tree/master/interviewDoc/Java
database	https://github.com/lalala2527/JavaInterview/tree/master/interviewDoc/Java/database
History	https://github.com/lalala2527/JavaInterview/commits/master/interviewDoc/Java/database/MySQL.md
	https://github.com/lalala2527/JavaInterview/commits/master/interviewDoc/Java/database/MySQL.md
JavaInterview	https://github.com/lalala2527/JavaInterview/tree/master
interviewDoc	https://github.com/lalala2527/JavaInterview/tree/master/interviewDoc
Java	https://github.com/lalala2527/JavaInterview/tree/master/interviewDoc/Java
database	https://github.com/lalala2527/JavaInterview/tree/master/interviewDoc/Java/database
Raw	https://github.com/lalala2527/JavaInterview/raw/refs/heads/master/interviewDoc/Java/database/MySQL.md
Java面试整理高清PDF下载	https://gitee.com/tiger-a/java-interview/blob/master/interviewDoc/Java/index.md
Java面试整理高清PDF下载	https://gitee.com/tiger-a/java-interview/blob/master/interviewDoc/Java/index.md
Java面试整理高清PDF下载	https://gitee.com/tiger-a/java-interview/blob/master/interviewDoc/Java/index.md
MySQL中的varchar和char有什么区别.	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql%E4%B8%AD%E7%9A%84varchar%E5%92%8Cchar%E6%9C%89%E4%BB%80%E4%B9%88%E5%8C%BA%E5%88%AB
varchar(10)和int(10)代表什么含义?	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#varchar10%E5%92%8Cint10%E4%BB%A3%E8%A1%A8%E4%BB%80%E4%B9%88%E5%90%AB%E4%B9%89
MySQL中varchar与char的区别以及varchar(50)中的50代表的涵义	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql%E4%B8%ADvarchar%E4%B8%8Echar%E7%9A%84%E5%8C%BA%E5%88%AB%E4%BB%A5%E5%8F%8Avarchar50%E4%B8%AD%E7%9A%8450%E4%BB%A3%E8%A1%A8%E7%9A%84%E6%B6%B5%E4%B9%89
请说明varchar和text的区别	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E8%AF%B7%E8%AF%B4%E6%98%8Evarchar%E5%92%8Ctext%E7%9A%84%E5%8C%BA%E5%88%AB
FLOAT和DOUBLE的区别是什么？	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#float%E5%92%8Cdouble%E7%9A%84%E5%8C%BA%E5%88%AB%E6%98%AF%E4%BB%80%E4%B9%88
如何在MySQL种获取当前日期？	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E5%A6%82%E4%BD%95%E5%9C%A8mysql%E7%A7%8D%E8%8E%B7%E5%8F%96%E5%BD%93%E5%89%8D%E6%97%A5%E6%9C%9F
MySQL中varchar与char的区别以及varchar(50)中的50代表的涵义	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql%E4%B8%ADvarchar%E4%B8%8Echar%E7%9A%84%E5%8C%BA%E5%88%AB%E4%BB%A5%E5%8F%8Avarchar50%E4%B8%AD%E7%9A%8450%E4%BB%A3%E8%A1%A8%E7%9A%84%E6%B6%B5%E4%B9%89
innodb的事务与日志的实现方式	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#innodb%E7%9A%84%E4%BA%8B%E5%8A%A1%E4%B8%8E%E6%97%A5%E5%BF%97%E7%9A%84%E5%AE%9E%E7%8E%B0%E6%96%B9%E5%BC%8F
MySQL的binlog有有几种录入格式?分别有什么区别?	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql%E7%9A%84binlog%E6%9C%89%E6%9C%89%E5%87%A0%E7%A7%8D%E5%BD%95%E5%85%A5%E6%A0%BC%E5%BC%8F%E5%88%86%E5%88%AB%E6%9C%89%E4%BB%80%E4%B9%88%E5%8C%BA%E5%88%AB
MySQL数据库cpu飙升怎么处理？	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql%E6%95%B0%E6%8D%AE%E5%BA%93cpu%E9%A3%99%E5%8D%87%E6%80%8E%E4%B9%88%E5%A4%84%E7%90%86
超大分页怎么处理?	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E8%B6%85%E5%A4%A7%E5%88%86%E9%A1%B5%E6%80%8E%E4%B9%88%E5%A4%84%E7%90%86
关心过业务系统里面的sql耗时吗?统计过慢查询吗?对慢查询都怎么优化过?	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E5%85%B3%E5%BF%83%E8%BF%87%E4%B8%9A%E5%8A%A1%E7%B3%BB%E7%BB%9F%E9%87%8C%E9%9D%A2%E7%9A%84sql%E8%80%97%E6%97%B6%E5%90%97%E7%BB%9F%E8%AE%A1%E8%BF%87%E6%85%A2%E6%9F%A5%E8%AF%A2%E5%90%97%E5%AF%B9%E6%85%A2%E6%9F%A5%E8%AF%A2%E9%83%BD%E6%80%8E%E4%B9%88%E4%BC%98%E5%8C%96%E8%BF%87
横向分表和纵向分表,可以分别举一个适合他们的例子吗?	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E6%A8%AA%E5%90%91%E5%88%86%E8%A1%A8%E5%92%8C%E7%BA%B5%E5%90%91%E5%88%86%E8%A1%A8%E5%8F%AF%E4%BB%A5%E5%88%86%E5%88%AB%E4%B8%BE%E4%B8%80%E4%B8%AA%E9%80%82%E5%90%88%E4%BB%96%E4%BB%AC%E7%9A%84%E4%BE%8B%E5%AD%90%E5%90%97
什么是存储过程？有哪些优缺点？	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E4%BB%80%E4%B9%88%E6%98%AF%E5%AD%98%E5%82%A8%E8%BF%87%E7%A8%8B%E6%9C%89%E5%93%AA%E4%BA%9B%E4%BC%98%E7%BC%BA%E7%82%B9
说一说三个范式	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E8%AF%B4%E4%B8%80%E8%AF%B4%E4%B8%89%E4%B8%AA%E8%8C%83%E5%BC%8F
MySQL的复制原理以及流程	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql%E7%9A%84%E5%A4%8D%E5%88%B6%E5%8E%9F%E7%90%86%E4%BB%A5%E5%8F%8A%E6%B5%81%E7%A8%8B
六种关联查询	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E5%85%AD%E7%A7%8D%E5%85%B3%E8%81%94%E6%9F%A5%E8%AF%A2
内连接分为三类	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E5%86%85%E8%BF%9E%E6%8E%A5%E5%88%86%E4%B8%BA%E4%B8%89%E7%B1%BB
外连接（LEFT JOIN/RIGHT JOIN）	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E5%A4%96%E8%BF%9E%E6%8E%A5left-joinright-join
联合查询（UNION与UNION ALL）	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E8%81%94%E5%90%88%E6%9F%A5%E8%AF%A2union%E4%B8%8Eunion-all
全连接（FULL JOIN）	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E5%85%A8%E8%BF%9E%E6%8E%A5full-join
UNION与UNION ALL的区别？	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#union%E4%B8%8Eunion-all%E7%9A%84%E5%8C%BA%E5%88%AB
SQL语句优化的一些方法？	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#sql%E8%AF%AD%E5%8F%A5%E4%BC%98%E5%8C%96%E7%9A%84%E4%B8%80%E4%BA%9B%E6%96%B9%E6%B3%95
MySQL由哪些部分组成, 分别用来做什么	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql%E7%94%B1%E5%93%AA%E4%BA%9B%E9%83%A8%E5%88%86%E7%BB%84%E6%88%90-%E5%88%86%E5%88%AB%E7%94%A8%E6%9D%A5%E5%81%9A%E4%BB%80%E4%B9%88
如果一个表有一列定义为TIMESTAMP，将发生什么？	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E5%A6%82%E6%9E%9C%E4%B8%80%E4%B8%AA%E8%A1%A8%E6%9C%89%E4%B8%80%E5%88%97%E5%AE%9A%E4%B9%89%E4%B8%BAtimestamp%E5%B0%86%E5%8F%91%E7%94%9F%E4%BB%80%E4%B9%88
MySQL 里记录货币用什么字段类型好	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql-%E9%87%8C%E8%AE%B0%E5%BD%95%E8%B4%A7%E5%B8%81%E7%94%A8%E4%BB%80%E4%B9%88%E5%AD%97%E6%AE%B5%E7%B1%BB%E5%9E%8B%E5%A5%BD
你们数据库是否支持emoji表情，如果不支持，如何操作？	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E4%BD%A0%E4%BB%AC%E6%95%B0%E6%8D%AE%E5%BA%93%E6%98%AF%E5%90%A6%E6%94%AF%E6%8C%81emoji%E8%A1%A8%E6%83%85%E5%A6%82%E6%9E%9C%E4%B8%8D%E6%94%AF%E6%8C%81%E5%A6%82%E4%BD%95%E6%93%8D%E4%BD%9C
MySQL 数据库作发布系统的存储，一天五万条以上的增量，预计运维三年,怎么优化？	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql-%E6%95%B0%E6%8D%AE%E5%BA%93%E4%BD%9C%E5%8F%91%E5%B8%83%E7%B3%BB%E7%BB%9F%E7%9A%84%E5%AD%98%E5%82%A8%E4%B8%80%E5%A4%A9%E4%BA%94%E4%B8%87%E6%9D%A1%E4%BB%A5%E4%B8%8A%E7%9A%84%E5%A2%9E%E9%87%8F-%E9%A2%84%E8%AE%A1%E8%BF%90%E7%BB%B4%E4%B8%89%E5%B9%B4%E6%80%8E%E4%B9%88%E4%BC%98%E5%8C%96
一个6亿的表a，一个3亿的表b，通过外间tid关联，你如何最快的查询出满足条件的第50000到第50200中的这200条数据记录。	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E4%B8%80%E4%B8%AA6%E4%BA%BF%E7%9A%84%E8%A1%A8a%E4%B8%80%E4%B8%AA3%E4%BA%BF%E7%9A%84%E8%A1%A8b%E9%80%9A%E8%BF%87%E5%A4%96%E9%97%B4tid%E5%85%B3%E8%81%94%E4%BD%A0%E5%A6%82%E4%BD%95%E6%9C%80%E5%BF%AB%E7%9A%84%E6%9F%A5%E8%AF%A2%E5%87%BA%E6%BB%A1%E8%B6%B3%E6%9D%A1%E4%BB%B6%E7%9A%84%E7%AC%AC50000%E5%88%B0%E7%AC%AC50200%E4%B8%AD%E7%9A%84%E8%BF%99200%E6%9D%A1%E6%95%B0%E6%8D%AE%E8%AE%B0%E5%BD%95
优化数据库的方法	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E4%BC%98%E5%8C%96%E6%95%B0%E6%8D%AE%E5%BA%93%E7%9A%84%E6%96%B9%E6%B3%95
简单描述 MySQL 中，索引，主键，唯一索引，联合索引的区别，对数据库的性能有什么影响（从读写两方面）	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E7%AE%80%E5%8D%95%E6%8F%8F%E8%BF%B0-mysql-%E4%B8%AD%E7%B4%A2%E5%BC%95%E4%B8%BB%E9%94%AE%E5%94%AF%E4%B8%80%E7%B4%A2%E5%BC%95%E8%81%94%E5%90%88%E7%B4%A2%E5%BC%95%E7%9A%84%E5%8C%BA%E5%88%AB%E5%AF%B9%E6%95%B0%E6%8D%AE%E5%BA%93%E7%9A%84%E6%80%A7%E8%83%BD%E6%9C%89%E4%BB%80%E4%B9%88%E5%BD%B1%E5%93%8D%E4%BB%8E%E8%AF%BB%E5%86%99%E4%B8%A4%E6%96%B9%E9%9D%A2
SQL 注入漏洞产生的原因？如何防止？	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#sql-%E6%B3%A8%E5%85%A5%E6%BC%8F%E6%B4%9E%E4%BA%A7%E7%94%9F%E7%9A%84%E5%8E%9F%E5%9B%A0%E5%A6%82%E4%BD%95%E9%98%B2%E6%AD%A2
存储时期	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E5%AD%98%E5%82%A8%E6%97%B6%E6%9C%9F
解释 MySQL 外连接、内连接与自连接的区别	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E8%A7%A3%E9%87%8A-mysql-%E5%A4%96%E8%BF%9E%E6%8E%A5%E5%86%85%E8%BF%9E%E6%8E%A5%E4%B8%8E%E8%87%AA%E8%BF%9E%E6%8E%A5%E7%9A%84%E5%8C%BA%E5%88%AB
存储引擎常用命令	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E5%AD%98%E5%82%A8%E5%BC%95%E6%93%8E%E5%B8%B8%E7%94%A8%E5%91%BD%E4%BB%A4
MySQL支持哪些存储引擎?	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql%E6%94%AF%E6%8C%81%E5%93%AA%E4%BA%9B%E5%AD%98%E5%82%A8%E5%BC%95%E6%93%8E
请说明InnoDB和MyISAM的区别	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E8%AF%B7%E8%AF%B4%E6%98%8Einnodb%E5%92%8Cmyisam%E7%9A%84%E5%8C%BA%E5%88%AB
innodb引擎的特性	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#innodb%E5%BC%95%E6%93%8E%E7%9A%84%E7%89%B9%E6%80%A7
什么是触发器，MySQL中都有哪些触发器？	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E4%BB%80%E4%B9%88%E6%98%AF%E8%A7%A6%E5%8F%91%E5%99%A8mysql%E4%B8%AD%E9%83%BD%E6%9C%89%E5%93%AA%E4%BA%9B%E8%A7%A6%E5%8F%91%E5%99%A8
InnoDB和MyISAM有什么区别?	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#innodb%E5%92%8Cmyisam%E6%9C%89%E4%BB%80%E4%B9%88%E5%8C%BA%E5%88%AB
myisamchk 是用来做什么的？	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#myisamchk-%E6%98%AF%E7%94%A8%E6%9D%A5%E5%81%9A%E4%BB%80%E4%B9%88%E7%9A%84
为什么要尽量设定一个主键?	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E4%B8%BA%E4%BB%80%E4%B9%88%E8%A6%81%E5%B0%BD%E9%87%8F%E8%AE%BE%E5%AE%9A%E4%B8%80%E4%B8%AA%E4%B8%BB%E9%94%AE
主键使用自增ID还是UUID?	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E4%B8%BB%E9%94%AE%E4%BD%BF%E7%94%A8%E8%87%AA%E5%A2%9Eid%E8%BF%98%E6%98%AFuuid
字段为什么要求定义为not null?	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E5%AD%97%E6%AE%B5%E4%B8%BA%E4%BB%80%E4%B9%88%E8%A6%81%E6%B1%82%E5%AE%9A%E4%B9%89%E4%B8%BAnot-null
如果要存储用户的密码散列,应该使用什么字段进行存储?	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E5%A6%82%E6%9E%9C%E8%A6%81%E5%AD%98%E5%82%A8%E7%94%A8%E6%88%B7%E7%9A%84%E5%AF%86%E7%A0%81%E6%95%A3%E5%88%97%E5%BA%94%E8%AF%A5%E4%BD%BF%E7%94%A8%E4%BB%80%E4%B9%88%E5%AD%97%E6%AE%B5%E8%BF%9B%E8%A1%8C%E5%AD%98%E5%82%A8
索引是个什么样的数据结构呢?	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E7%B4%A2%E5%BC%95%E6%98%AF%E4%B8%AA%E4%BB%80%E4%B9%88%E6%A0%B7%E7%9A%84%E6%95%B0%E6%8D%AE%E7%BB%93%E6%9E%84%E5%91%A2
唯一索引比普通索引快吗, 为什么	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E5%94%AF%E4%B8%80%E7%B4%A2%E5%BC%95%E6%AF%94%E6%99%AE%E9%80%9A%E7%B4%A2%E5%BC%95%E5%BF%AB%E5%90%97-%E4%B8%BA%E4%BB%80%E4%B9%88
索引的优缺点	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E7%B4%A2%E5%BC%95%E7%9A%84%E4%BC%98%E7%BC%BA%E7%82%B9
做过哪些MySQL索引相关优化	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E5%81%9A%E8%BF%87%E5%93%AA%E4%BA%9Bmysql%E7%B4%A2%E5%BC%95%E7%9B%B8%E5%85%B3%E4%BC%98%E5%8C%96
怎么看到为表格定义的所有索引？	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E6%80%8E%E4%B9%88%E7%9C%8B%E5%88%B0%E4%B8%BA%E8%A1%A8%E6%A0%BC%E5%AE%9A%E4%B9%89%E7%9A%84%E6%89%80%E6%9C%89%E7%B4%A2%E5%BC%95
索引的基础	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E7%B4%A2%E5%BC%95%E7%9A%84%E5%9F%BA%E7%A1%80
创建索引的语法	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E5%88%9B%E5%BB%BA%E7%B4%A2%E5%BC%95%E7%9A%84%E8%AF%AD%E6%B3%95
索引对性能的影响：	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E7%B4%A2%E5%BC%95%E5%AF%B9%E6%80%A7%E8%83%BD%E7%9A%84%E5%BD%B1%E5%93%8D
索引的类型	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E7%B4%A2%E5%BC%95%E7%9A%84%E7%B1%BB%E5%9E%8B
索引的区别	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E7%B4%A2%E5%BC%95%E7%9A%84%E5%8C%BA%E5%88%AB
MySQL索引的创建原则	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql%E7%B4%A2%E5%BC%95%E7%9A%84%E5%88%9B%E5%BB%BA%E5%8E%9F%E5%88%99
索引的使用场景	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E7%B4%A2%E5%BC%95%E7%9A%84%E4%BD%BF%E7%94%A8%E5%9C%BA%E6%99%AF
索引分类	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E7%B4%A2%E5%BC%95%E5%88%86%E7%B1%BB
MySQL索引的注意事项	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql%E7%B4%A2%E5%BC%95%E7%9A%84%E6%B3%A8%E6%84%8F%E4%BA%8B%E9%A1%B9
MySQL索引的原理	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql%E7%B4%A2%E5%BC%95%E7%9A%84%E5%8E%9F%E7%90%86
解题方法	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E8%A7%A3%E9%A2%98%E6%96%B9%E6%B3%95
创建MySQL联合索引应该注意什么？	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E5%88%9B%E5%BB%BAmysql%E8%81%94%E5%90%88%E7%B4%A2%E5%BC%95%E5%BA%94%E8%AF%A5%E6%B3%A8%E6%84%8F%E4%BB%80%E4%B9%88
列值为NULL时，查询是否会用到索引？	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E5%88%97%E5%80%BC%E4%B8%BAnull%E6%97%B6%E6%9F%A5%E8%AF%A2%E6%98%AF%E5%90%A6%E4%BC%9A%E7%94%A8%E5%88%B0%E7%B4%A2%E5%BC%95
以下语句是否会应用索引：SELECT FROM users WHERE YEAR(adddate) < 2007;	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E4%BB%A5%E4%B8%8B%E8%AF%AD%E5%8F%A5%E6%98%AF%E5%90%A6%E4%BC%9A%E5%BA%94%E7%94%A8%E7%B4%A2%E5%BC%95select-from-users-where-yearadddate--2007
MyISAM索引实现？	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#myisam%E7%B4%A2%E5%BC%95%E5%AE%9E%E7%8E%B0
MyISAM索引与InnoDB索引的区别？	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#myisam%E7%B4%A2%E5%BC%95%E4%B8%8Einnodb%E7%B4%A2%E5%BC%95%E7%9A%84%E5%8C%BA%E5%88%AB
使用索引查询一定能提高查询的性能吗？为什么	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E4%BD%BF%E7%94%A8%E7%B4%A2%E5%BC%95%E6%9F%A5%E8%AF%A2%E4%B8%80%E5%AE%9A%E8%83%BD%E6%8F%90%E9%AB%98%E6%9F%A5%E8%AF%A2%E7%9A%84%E6%80%A7%E8%83%BD%E5%90%97%E4%B8%BA%E4%BB%80%E4%B9%88
什么情况下设置了索引但无法使用	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E4%BB%80%E4%B9%88%E6%83%85%E5%86%B5%E4%B8%8B%E8%AE%BE%E7%BD%AE%E4%BA%86%E7%B4%A2%E5%BC%95%E4%BD%86%E6%97%A0%E6%B3%95%E4%BD%BF%E7%94%A8
超键、候选键、主键、外键分别是什么？	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E8%B6%85%E9%94%AE%E5%80%99%E9%80%89%E9%94%AE%E4%B8%BB%E9%94%AE%E5%A4%96%E9%94%AE%E5%88%86%E5%88%AB%E6%98%AF%E4%BB%80%E4%B9%88
简单说一说drop、delete与truncate的区别	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E7%AE%80%E5%8D%95%E8%AF%B4%E4%B8%80%E8%AF%B4dropdelete%E4%B8%8Etruncate%E7%9A%84%E5%8C%BA%E5%88%AB
drop、delete与truncate分别在什么场景之下使用？	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#dropdelete%E4%B8%8Etruncate%E5%88%86%E5%88%AB%E5%9C%A8%E4%BB%80%E4%B9%88%E5%9C%BA%E6%99%AF%E4%B9%8B%E4%B8%8B%E4%BD%BF%E7%94%A8
B-Tree 和 B+Tree	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#b-tree-%E5%92%8C-btree
为什么 B+Tree 比 B-Tree 更适合实际应用中操作系统的文件索引和数据库索引？**	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E4%B8%BA%E4%BB%80%E4%B9%88-btree-%E6%AF%94-b-tree-%E6%9B%B4%E9%80%82%E5%90%88%E5%AE%9E%E9%99%85%E5%BA%94%E7%94%A8%E4%B8%AD%E6%93%8D%E4%BD%9C%E7%B3%BB%E7%BB%9F%E7%9A%84%E6%96%87%E4%BB%B6%E7%B4%A2%E5%BC%95%E5%92%8C%E6%95%B0%E6%8D%AE%E5%BA%93%E7%B4%A2%E5%BC%95
什么是视图？以及视图的使用场景有哪些？	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E4%BB%80%E4%B9%88%E6%98%AF%E8%A7%86%E5%9B%BE%E4%BB%A5%E5%8F%8A%E8%A7%86%E5%9B%BE%E7%9A%84%E4%BD%BF%E7%94%A8%E5%9C%BA%E6%99%AF%E6%9C%89%E5%93%AA%E4%BA%9B
Hash索引和B+树所有有什么区别或者说优劣呢?	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#hash%E7%B4%A2%E5%BC%95%E5%92%8Cb%E6%A0%91%E6%89%80%E6%9C%89%E6%9C%89%E4%BB%80%E4%B9%88%E5%8C%BA%E5%88%AB%E6%88%96%E8%80%85%E8%AF%B4%E4%BC%98%E5%8A%A3%E5%91%A2
为什么用 B+ 树做索引而不用哈希表做索引?	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E4%B8%BA%E4%BB%80%E4%B9%88%E7%94%A8-b-%E6%A0%91%E5%81%9A%E7%B4%A2%E5%BC%95%E8%80%8C%E4%B8%8D%E7%94%A8%E5%93%88%E5%B8%8C%E8%A1%A8%E5%81%9A%E7%B4%A2%E5%BC%95
索引是什么？有什么作用以及优缺点？	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E7%B4%A2%E5%BC%95%E6%98%AF%E4%BB%80%E4%B9%88%E6%9C%89%E4%BB%80%E4%B9%88%E4%BD%9C%E7%94%A8%E4%BB%A5%E5%8F%8A%E4%BC%98%E7%BC%BA%E7%82%B9
上面提到了B+树在满足聚簇索引和覆盖索引的时候不需要回表查询数据,什么是聚簇索引?	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E4%B8%8A%E9%9D%A2%E6%8F%90%E5%88%B0%E4%BA%86b%E6%A0%91%E5%9C%A8%E6%BB%A1%E8%B6%B3%E8%81%9A%E7%B0%87%E7%B4%A2%E5%BC%95%E5%92%8C%E8%A6%86%E7%9B%96%E7%B4%A2%E5%BC%95%E7%9A%84%E6%97%B6%E5%80%99%E4%B8%8D%E9%9C%80%E8%A6%81%E5%9B%9E%E8%A1%A8%E6%9F%A5%E8%AF%A2%E6%95%B0%E6%8D%AE%E4%BB%80%E4%B9%88%E6%98%AF%E8%81%9A%E7%B0%87%E7%B4%A2%E5%BC%95
非聚簇索引一定会回表查询吗?	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E9%9D%9E%E8%81%9A%E7%B0%87%E7%B4%A2%E5%BC%95%E4%B8%80%E5%AE%9A%E4%BC%9A%E5%9B%9E%E8%A1%A8%E6%9F%A5%E8%AF%A2%E5%90%97
在建立索引的时候,都有哪些需要考虑的因素呢?	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E5%9C%A8%E5%BB%BA%E7%AB%8B%E7%B4%A2%E5%BC%95%E7%9A%84%E6%97%B6%E5%80%99%E9%83%BD%E6%9C%89%E5%93%AA%E4%BA%9B%E9%9C%80%E8%A6%81%E8%80%83%E8%99%91%E7%9A%84%E5%9B%A0%E7%B4%A0%E5%91%A2
联合索引是什么?为什么需要注意联合索引中的顺序?	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E8%81%94%E5%90%88%E7%B4%A2%E5%BC%95%E6%98%AF%E4%BB%80%E4%B9%88%E4%B8%BA%E4%BB%80%E4%B9%88%E9%9C%80%E8%A6%81%E6%B3%A8%E6%84%8F%E8%81%94%E5%90%88%E7%B4%A2%E5%BC%95%E4%B8%AD%E7%9A%84%E9%A1%BA%E5%BA%8F
创建的索引有没有被使用到?或者说怎么才可以知道这条语句运行很慢的原因?	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E5%88%9B%E5%BB%BA%E7%9A%84%E7%B4%A2%E5%BC%95%E6%9C%89%E6%B2%A1%E6%9C%89%E8%A2%AB%E4%BD%BF%E7%94%A8%E5%88%B0%E6%88%96%E8%80%85%E8%AF%B4%E6%80%8E%E4%B9%88%E6%89%8D%E5%8F%AF%E4%BB%A5%E7%9F%A5%E9%81%93%E8%BF%99%E6%9D%A1%E8%AF%AD%E5%8F%A5%E8%BF%90%E8%A1%8C%E5%BE%88%E6%85%A2%E7%9A%84%E5%8E%9F%E5%9B%A0
那么在哪些情况下会发生针对该列创建了索引但是在查询的时候并没有使用呢?	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E9%82%A3%E4%B9%88%E5%9C%A8%E5%93%AA%E4%BA%9B%E6%83%85%E5%86%B5%E4%B8%8B%E4%BC%9A%E5%8F%91%E7%94%9F%E9%92%88%E5%AF%B9%E8%AF%A5%E5%88%97%E5%88%9B%E5%BB%BA%E4%BA%86%E7%B4%A2%E5%BC%95%E4%BD%86%E6%98%AF%E5%9C%A8%E6%9F%A5%E8%AF%A2%E7%9A%84%E6%97%B6%E5%80%99%E5%B9%B6%E6%B2%A1%E6%9C%89%E4%BD%BF%E7%94%A8%E5%91%A2
什么是事务?	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E4%BB%80%E4%B9%88%E6%98%AF%E4%BA%8B%E5%8A%A1
数据库的乐观锁和悲观锁是什么？	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E6%95%B0%E6%8D%AE%E5%BA%93%E7%9A%84%E4%B9%90%E8%A7%82%E9%94%81%E5%92%8C%E6%82%B2%E8%A7%82%E9%94%81%E6%98%AF%E4%BB%80%E4%B9%88
ACID是什么?可以详细说一下吗?	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#acid%E6%98%AF%E4%BB%80%E4%B9%88%E5%8F%AF%E4%BB%A5%E8%AF%A6%E7%BB%86%E8%AF%B4%E4%B8%80%E4%B8%8B%E5%90%97
同时有多个事务在进行会怎么样呢?	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E5%90%8C%E6%97%B6%E6%9C%89%E5%A4%9A%E4%B8%AA%E4%BA%8B%E5%8A%A1%E5%9C%A8%E8%BF%9B%E8%A1%8C%E4%BC%9A%E6%80%8E%E4%B9%88%E6%A0%B7%E5%91%A2
Myql 中的事务回滚机制概述	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#myql-%E4%B8%AD%E7%9A%84%E4%BA%8B%E5%8A%A1%E5%9B%9E%E6%BB%9A%E6%9C%BA%E5%88%B6%E6%A6%82%E8%BF%B0
并发事务带来哪些问题?	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E5%B9%B6%E5%8F%91%E4%BA%8B%E5%8A%A1%E5%B8%A6%E6%9D%A5%E5%93%AA%E4%BA%9B%E9%97%AE%E9%A2%98
怎么解决这些问题呢?MySQL的事务隔离级别了解吗?	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E6%80%8E%E4%B9%88%E8%A7%A3%E5%86%B3%E8%BF%99%E4%BA%9B%E9%97%AE%E9%A2%98%E5%91%A2mysql%E7%9A%84%E4%BA%8B%E5%8A%A1%E9%9A%94%E7%A6%BB%E7%BA%A7%E5%88%AB%E4%BA%86%E8%A7%A3%E5%90%97
Innodb使用的是哪种隔离级别呢?	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#innodb%E4%BD%BF%E7%94%A8%E7%9A%84%E6%98%AF%E5%93%AA%E7%A7%8D%E9%9A%94%E7%A6%BB%E7%BA%A7%E5%88%AB%E5%91%A2
MySQL 中有哪几种锁？	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql-%E4%B8%AD%E6%9C%89%E5%93%AA%E5%87%A0%E7%A7%8D%E9%94%81
对MySQL的锁了解吗?	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E5%AF%B9mysql%E7%9A%84%E9%94%81%E4%BA%86%E8%A7%A3%E5%90%97
锁机制与InnoDB锁算法	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E9%94%81%E6%9C%BA%E5%88%B6%E4%B8%8Einnodb%E9%94%81%E7%AE%97%E6%B3%95
MySQL都有哪些锁呢?像上面那样子进行锁定岂不是有点阻碍并发效率了?	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql%E9%83%BD%E6%9C%89%E5%93%AA%E4%BA%9B%E9%94%81%E5%91%A2%E5%83%8F%E4%B8%8A%E9%9D%A2%E9%82%A3%E6%A0%B7%E5%AD%90%E8%BF%9B%E8%A1%8C%E9%94%81%E5%AE%9A%E5%B2%82%E4%B8%8D%E6%98%AF%E6%9C%89%E7%82%B9%E9%98%BB%E7%A2%8D%E5%B9%B6%E5%8F%91%E6%95%88%E7%8E%87%E4%BA%86
锁的优化策略	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E9%94%81%E7%9A%84%E4%BC%98%E5%8C%96%E7%AD%96%E7%95%A5
Explain 性能分析	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#explain-%E6%80%A7%E8%83%BD%E5%88%86%E6%9E%90
如何优化SQL	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#%E5%A6%82%E4%BD%95%E4%BC%98%E5%8C%96sql
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql中的varchar和char有什么区别
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#varchar10和int10代表什么含义
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql中varchar与char的区别以及varchar50中的50代表的涵义
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#请说明varchar和text的区别
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#float和double的区别是什么
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#如何在mysql种获取当前日期
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql中varchar与char的区别以及varchar50中的50代表的涵义-1
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#innodb的事务与日志的实现方式
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql的binlog有有几种录入格式分别有什么区别
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql数据库cpu飙升到500的话他怎么处理
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#超大分页怎么处理
	https://camo.githubusercontent.com/2c2cbcb83264d43b967c5144c045c7d7bec04e39bb1de84702f8d1bd4b16aa45/68747470733a2f2f696d67732e69747875657975616e2e636f6d2f3939303931332d32303139303830363039313433393534382d3830363439383133352e706e67
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#关心过业务系统里面的sql耗时吗统计过慢查询吗对慢查询都怎么优化过
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#横向分表和纵向分表可以分别举一个适合他们的例子吗
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#什么是存储过程有哪些优缺点
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#说一说三个范式
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql的复制原理以及流程
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#六种关联查询
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#内连接分为三类
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#外连接left-joinright-join
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#联合查询union与union-all
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#全连接full-join
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#union与union-all的区别
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#sql语句优化的一些方法
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql由哪些部分组成-分别用来做什么
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#如果一个表有一列定义为timestamp将发生什么
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql-里记录货币用什么字段类型好
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#你们数据库是否支持emoji表情如果不支持如何操作
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql-数据库作发布系统的存储一天五万条以上的增量-预计运维三年怎么优化
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#一个6亿的表a一个3亿的表b通过外间tid关联你如何最快的查询出满足条件的第50000到第50200中的这200条数据记录
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#优化数据库的方法
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#简单描述-mysql-中索引主键唯一索引联合索引的区别对数据库的性能有什么影响从读写两方面
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#sql-注入漏洞产生的原因如何防止
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#存储时期
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#解释-mysql-外连接内连接与自连接的区别
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#存储引擎常用命令
	https://camo.githubusercontent.com/ad15bb1f159ea58f25688dccb44123744faaf4f7e27675ab0dc6fde682f04761/68747470733a2f2f67697465652e636f6d2f67736a7177796c2f696d616765735f7265706f2f7261772f6d61737465722f323032312d332d31312f32303231303332353130323730312e706e67
	https://camo.githubusercontent.com/ae575fcfe8edd9cf91d0f744a5a846eadf40806c65ec964fd50b3a9c04d2407a/68747470733a2f2f67697465652e636f6d2f67736a7177796c2f696d616765735f7265706f2f7261772f6d61737465722f323032312d332d31312f32303231303332353130323735332e706e67
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql支持哪些存储引擎
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#请说明innodb和myisam的区别
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#innodb引擎的特性
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#什么是触发器mysql中都有哪些触发器
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#innodb和myisam有什么区别
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#myisamchk-是用来做什么的
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#为什么要尽量设定一个主键
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#主键使用自增id还是uuid
	https://camo.githubusercontent.com/926403ec639ebdb642a2145ced6e85d61c243151b2e032add65113fa5c4b7006/68747470733a2f2f696d67732e69747875657975616e2e636f6d2f3939303931332d32303139303830363039313431363731342d3738303935303033302e706e67
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#字段为什么要求定义为not-null
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#如果要存储用户的密码散列应该使用什么字段进行存储
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#索引是个什么样的数据结构呢
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#唯一索引比普通索引快吗-为什么
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#索引的优缺点
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#做过哪些mysql索引相关优化
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#怎么看到为表格定义的所有索引
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#索引的基础
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#创建索引的语法
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#索引对性能的影响
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#索引的类型
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#索引的区别
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql索引的创建原则
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#索引的使用场景
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#索引分类
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql索引的注意事项
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql索引的原理
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#解题方法
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#创建mysql联合索引应该注意什么
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#列值为null时查询是否会用到索引
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#以下语句是否会应用索引select-from-users-where-yearadddate--2007
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#myisam索引实现
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#myisam索引与innodb索引的区别
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#使用索引查询一定能提高查询的性能吗为什么
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#什么情况下设置了索引但无法使用
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#超键候选键主键外键分别是什么
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#简单说一说dropdelete与truncate的区别
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#dropdelete与truncate分别在什么场景之下使用
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#b-tree-和-btree
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#为什么-btree-比-b-tree-更适合实际应用中操作系统的文件索引和数据库索引
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#什么是视图以及视图的使用场景有哪些
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#hash索引和b树所有有什么区别或者说优劣呢
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#为什么用-b-树做索引而不用哈希表做索引
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#索引是什么有什么作用以及优缺点
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#上面提到了b树在满足聚簇索引和覆盖索引的时候不需要回表查询数据什么是聚簇索引
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#非聚簇索引一定会回表查询吗
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#在建立索引的时候都有哪些需要考虑的因素呢
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#联合索引是什么为什么需要注意联合索引中的顺序
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#创建的索引有没有被使用到或者说怎么才可以知道这条语句运行很慢的原因
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#那么在哪些情况下会发生针对该列创建了索引但是在查询的时候并没有使用呢
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#什么是事务
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#数据库的乐观锁和悲观锁是什么
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#acid是什么可以详细说一下吗
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#同时有多个事务在进行会怎么样呢
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#myql-中的事务回滚机制概述
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#并发事务带来哪些问题
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#怎么解决这些问题呢mysql的事务隔离级别了解吗
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#innodb使用的是哪种隔离级别呢
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql-中有哪几种锁
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#对mysql的锁了解吗
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#锁机制与innodb锁算法
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#mysql都有哪些锁呢像上面那样子进行锁定岂不是有点阻碍并发效率了
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#锁的优化策略
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#explain-性能分析
	https://camo.githubusercontent.com/ab8a9040f82fb765b9bbb6cc1c419654030a3eec91caddfaa0b0a0ccb6dc3253/68747470733a2f2f70332d6a75656a696e2e62797465696d672e636f6d2f746f732d636e2d692d6b3375316662706663702f35613161366162346665333834326461383436653839663639646536326666327e74706c762d6b3375316662706663702d77617465726d61726b2e696d616765
	https://github.com/lalala2527/JavaInterview/blob/master/interviewDoc/Java/database/MySQL.md#如何优化sql
	https://camo.githubusercontent.com/8de777862671bba9d38a3d99e00530466fbe27a25ef30a649bd1be164e1300be/68747470733a2f2f67697465652e636f6d2f67736a7177796c2f696d616765735f7265706f2f7261772f6d61737465722f323032312d332d31312f32303231303332353130343431372e706e67
	https://camo.githubusercontent.com/d381118bb9ffa9e6d5ec558c3e285bf6605a8a16a86a726af34d0bb276c338e8/68747470733a2f2f67697465652e636f6d2f67736a7177796c2f696d616765735f7265706f2f7261772f6d61737465722f323032312d332d31312f32303231303332353130343634312e706e67
	https://camo.githubusercontent.com/031cb86fec6a6d1ac41c60e2daf8da618024339710682a7d324d3ee47e1b2938/68747470733a2f2f67697465652e636f6d2f67736a7177796c2f696d616765735f7265706f2f7261772f6d61737465722f323032312d332d31312f32303231303332353130343830372e706e67
	https://camo.githubusercontent.com/7bd6245a4901fdc3deda8132ddde296eefb576c8f5abe8c46f8e8ca267037c36/68747470733a2f2f67697465652e636f6d2f67736a7177796c2f696d616765735f7265706f2f7261772f6d61737465722f323032312d332d31312f32303231303332353130343932332e706e67
	https://camo.githubusercontent.com/195dc8dde33626a5c4f102b95aec4980c31e1a4faf35e50a17d2c787f2512c15/68747470733a2f2f67697465652e636f6d2f67736a7177796c2f696d616765735f7265706f2f7261772f6d61737465722f323032312d332d31312f32303231303332353130353133312e706e67
	https://camo.githubusercontent.com/247a783acedc46ce90d2775c7ae8a952db3a58ada9a066a865f17f57a78be648/68747470733a2f2f67697465652e636f6d2f67736a7177796c2f696d616765735f7265706f2f7261772f6d61737465722f323032312d332d31312f32303231303332353130353135382e706e67
	https://camo.githubusercontent.com/4bd37c01e612b921815b88a84a71c43513755cf1aa5e8ba715615ce61052a44f/68747470733a2f2f67697465652e636f6d2f67736a7177796c2f696d616765735f7265706f2f7261772f6d61737465722f323032312d332d31312f32303231303332353130353231332e706e67
	https://github.com
Terms	https://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacy	https://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Security	https://github.com/security
Status	https://www.githubstatus.com/
Community	https://github.community/
Docs	https://docs.github.com/
Contact	https://support.github.com?tags=dotcom-footer

Viewport: width=device-width

URLs of crawlers that visited me.