| react-profiling | 0 |
| react-import-map | react,react-dom,react-dom/client,react-dom/profiling,react-is,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@b8488ee2c322 |
| route-pattern | /:user_id/:repository/blob/*name(/*path) |
| route-controller | blob |
| route-action | show |
| fetch-nonce | v2:25aa820e-35e1-b792-0c71-bd3ba44d588c |
| current-catalog-service-hash | f3abb0cc802f3d7b95fc8762b94bdcb13bf39634c40c357301c4aa1d67a256fb |
| request-id | D44A:29FFA9:1DB8FD3:259F2AF:6B015CAA |
| html-safe-nonce | 8b1f77579ab2dbc4ba53b87f1bf3196fb48b32d589535debbe59b1fa0cadfec8 |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJENDRBOjI5RkZBOToxREI4RkQzOjI1OUYyQUY6NkIwMTVDQUEiLCJ2aXNpdG9yX2lkIjoiNjQ0Mzg2NDg1NzYxOTAyOTE2MiIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9 |
| visitor-hmac | 113482f1af72c9dda40a793116a5f6b8bd2e2e0f44dde59ee424745bd9e8a013 |
| hovercard-subject-tag | repository:616979806 |
| 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/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md |
| twitter:image | https://opengraph.githubassets.com/9218ad7cffcd91884df7e6051db43fdd6e6ef12c33001fe2bd2000b646e13840/Cp99nice/JavaGuide |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/9218ad7cffcd91884df7e6051db43fdd6e6ef12c33001fe2bd2000b646e13840/Cp99nice/JavaGuide |
| og:image:alt | 「Java学习+面试指南」一份涵盖大部分 Java 程序员所需要掌握的核心知识。准备 Java 面试,首选 JavaGuide! - Cp99nice/JavaGuide |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| hostname | github.com |
| expected-hostname | github.com |
| None | cc5dfdd32f62ebd3223cab3af3aa2b268d3605218237326a48a99d1efd89495c |
| turbo-cache-control | no-cache |
| go-import | github.com/Cp99nice/JavaGuide git https://github.com/Cp99nice/JavaGuide.git |
| octolytics-dimension-user_id | 52906517 |
| octolytics-dimension-user_login | Cp99nice |
| octolytics-dimension-repository_id | 616979806 |
| octolytics-dimension-repository_nwo | Cp99nice/JavaGuide |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | true |
| octolytics-dimension-repository_parent_id | 132464395 |
| octolytics-dimension-repository_parent_nwo | Snailclimb/JavaGuide |
| octolytics-dimension-repository_network_root_id | 132464395 |
| octolytics-dimension-repository_network_root_nwo | Snailclimb/JavaGuide |
| 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 | 8c77c9e8439031ad54c75a250694842892f693e1 |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
| Skip to content | https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#start-of-content |
| https://github.com/ |
| Sign in | https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2FCp99nice%2FJavaGuide%2Fblob%2Fmain%2Fdocs%2Fdatabase%2Fsql%2Fsql-syntax-summary.md |
| GitHubRepository hosting, code review, and collaboration | https://github.com/platform |
| CopilotAI coding agent for tasks, projects, and automated work | https://github.com/features/copilot |
| ActionsCI/CD and automation | https://github.com/features/actions |
| Code QualityQuality analysis, fixes, and enforcement | https://github.com/features/code-quality |
| CodespacesCloud development environments | https://github.com/features/codespaces |
| Code SecurityVulnerability detection and remediation | https://github.com/security/advanced-security/code-security |
| Secret ProtectionSecret scanning and leak prevention | https://github.com/security/advanced-security/secret-protection |
| All Features | https://github.com/features |
| Documentation | https://docs.github.com/en |
| Training | https://learn.github.com/skills |
| Certifications | https://learn.github.com/credentials |
| Build with Copilot | https://github.com/features/ai |
| Customize Copilot | https://docs.github.com/en/copilot/how-tos/copilot-on-github/customize-copilot/customize-copilot-overview |
| Integrations | https://github.com/marketplace |
| Trending repos | https://github.com/trending |
| GitHub Sponsors | https://github.com/open-source/sponsors |
| Developer articles | https://github.com/resources/articles |
| ChangelogYour source for the latest features, improvements, and fixes across GitHub products, all in one place. | https://github.blog/changelog/ |
| Enterprises | https://github.com/enterprise |
| Team | https://github.com/team |
| Startups | https://github.com/enterprise/startups |
| Nonprofits | https://github.com/solutions/industry/nonprofits |
| 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 |
| See all industries | https://github.com/solutions/industry |
| Why GitHub | https://github.com/why-github |
| Customer Stories | https://github.com/customer-stories |
| Business insights | https://github.com/solutions/executive-insights |
| Trust Center | https://github.com/trust-center |
| GitHub Advanced SecurityEnterprise-grade code security | 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 |
| Documentation | https://docs.github.com/en |
| Resource center | https://github.com/resources |
| Blog | https://github.blog/ |
| Events & webinars | https://github.com/resources/events |
| Community Forum | https://github.com/orgs/community/discussions |
| Customer Stories | https://github.com/customer-stories |
| Integrations | https://github.com/marketplace |
| Customer support | https://help.github.com/ |
| Training | https://learn.github.com/skills |
| GitHub Status | https://www.githubstatus.com/ |
| About | https://github.com/about |
| Partners | https://github.com/partners |
| Changelog | https://github.blog/changelog/ |
| GitHub UniverseThe event for developers, by developers — talks, workshops, and what’s next for GitHub. | https://githubuniverse.com/ |
| Pricing | https://github.com/pricing |
| Sign in | https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2FCp99nice%2FJavaGuide%2Fblob%2Fmain%2Fdocs%2Fdatabase%2Fsql%2Fsql-syntax-summary.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=Cp99nice%2FJavaGuide |
| Reload | https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md |
| Reload | https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md |
| Reload | https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md |
| Cp99nice | https://github.com/Cp99nice |
| JavaGuide | https://github.com/Cp99nice/JavaGuide |
| Code | https://github.com/Cp99nice/JavaGuide |
| Pull requests | https://github.com/Cp99nice/JavaGuide/pulls |
| Actions | https://github.com/Cp99nice/JavaGuide/actions |
| Projects | https://github.com/Cp99nice/JavaGuide/projects |
| Security and quality | https://github.com/Cp99nice/JavaGuide/security |
| Insights | https://github.com/Cp99nice/JavaGuide/pulse |
| https://github.com/Cp99nice/JavaGuide |
| JavaGuide | https://github.com/Cp99nice/JavaGuide/tree/main |
| docs | https://github.com/Cp99nice/JavaGuide/tree/main/docs |
| database | https://github.com/Cp99nice/JavaGuide/tree/main/docs/database |
| sql | https://github.com/Cp99nice/JavaGuide/tree/main/docs/database/sql |
| History | https://github.com/Cp99nice/JavaGuide/commits/main/docs/database/sql/sql-syntax-summary.md |
| https://github.com/Cp99nice/JavaGuide/commits/main/docs/database/sql/sql-syntax-summary.md |
| JavaGuide | https://github.com/Cp99nice/JavaGuide/tree/main |
| docs | https://github.com/Cp99nice/JavaGuide/tree/main/docs |
| database | https://github.com/Cp99nice/JavaGuide/tree/main/docs/database |
| sql | https://github.com/Cp99nice/JavaGuide/tree/main/docs/database/sql |
| Raw | https://github.com/Cp99nice/JavaGuide/raw/refs/heads/main/docs/database/sql/sql-syntax-summary.md |
| SQL 语法速成手册 | https://juejin.cn/post/6844903790571700231 |
| MySQL 超全教程 | https://www.begtut.com/mysql/mysql-tutorial.html |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#基本概念 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#数据库术语 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#sql-语法 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#sql-语法结构 |
| https://camo.githubusercontent.com/f358b6b7c89c23a9f3bce8022eaa3cc5df19daba04c76c2837568e34bdd914d4/68747470733a2f2f70332d6a75656a696e2e62797465696d672e636f6d2f746f732d636e2d692d6b3375316662706663702f63623638346434633735666334333065393261616565323236303639633764617e74706c762d6b3375316662706663702d7a6f6f6d2d312e696d616765 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#sql-语法要点 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#sql-分类 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#数据定义语言ddl |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#数据操纵语言dml |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#事务控制语言tcl |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#数据控制语言dcl |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#增删改查 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#插入数据 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#更新数据 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#删除数据 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#查询数据 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#排序 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#分组 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#子查询 |
| https://camo.githubusercontent.com/e8295eddaea62dadd543ccf86830fd7b54f16cc9c0fabf13386fa47408a4ea2f/68747470733a2f2f70332d6a75656a696e2e62797465696d672e636f6d2f746f732d636e2d692d6b3375316662706663702f63343339646131663564346534623030626466613433313662393333643736347e74706c762d6b3375316662706663702d7a6f6f6d2d312e696d616765 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#where |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#in-和-between |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#andornot |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#like |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#连接 |
| https://camo.githubusercontent.com/de69888e6f9d4c12f2ae2dc8c7d923452ccb4aca42d80e5b66efb7eb9a1eb422/68747470733a2f2f70332d6a75656a696e2e62797465696d672e636f6d2f746f732d636e2d692d6b3375316662706663702f37303136373039343266306634356433613361323138376364303461313261647e74706c762d6b3375316662706663702d7a6f6f6d2d312e696d616765 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#组合 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#函数 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#文本处理 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#日期和时间处理 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#数值处理 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#汇总 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#数据定义 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#数据库database |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#创建数据库 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#删除数据库 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#选择数据库 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#数据表table |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#创建数据表 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#删除数据表 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#修改数据表 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#视图view |
| https://camo.githubusercontent.com/4bdc9e66738e97f1e7b71aa561d994dfd42fd282bc0efb9f2c86adf6013839f7/68747470733a2f2f70332d6a75656a696e2e62797465696d672e636f6d2f746f732d636e2d692d6b3375316662706663702f65633463393735323936656134613730393738373964616337633335333837387e74706c762d6b3375316662706663702d7a6f6f6d2d312e696d616765 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#创建视图 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#删除视图 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#索引index |
| MySQL 索引详解 | https://javaguide.cn/database/mysql/mysql-index.html |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#创建索引 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#添加索引 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#创建唯一索引 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#删除索引 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#约束 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#事务处理 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#权限控制 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#创建账户 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#修改账户名 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#删除账户 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#查看权限 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#授予权限 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#删除权限 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#更改密码 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#存储过程 |
| https://camo.githubusercontent.com/006d0eea4f57b05b9b8b518fe78f62fb5fd79bca333c22c34364b60aeb0811d9/68747470733a2f2f70332d6a75656a696e2e62797465696d672e636f6d2f746f732d636e2d692d6b3375316662706663702f36306166646339633961353934663037393732376563363461326536393861337e74706c762d6b3375316662706663702d7a6f6f6d2d312e696d616765 |
| https://camo.githubusercontent.com/25a72d68f91a0ce8504fed5baee49931a9ba8e79723761e2bb920e41a9351504/68747470733a2f2f70332d6a75656a696e2e62797465696d672e636f6d2f746f732d636e2d692d6b3375316662706663702f39336135653031316164653434353065626661356438323035373533326134397e74706c762d6b3375316662706663702d7a6f6f6d2d312e696d616765 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#创建存储过程 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#使用存储过程 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#游标 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#触发器 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#创建触发器 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#查看触发器 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#删除触发器 |
| https://github.com/Cp99nice/JavaGuide/blob/main/docs/database/sql/sql-syntax-summary.md#文章推荐 |
| 后端程序员必备:SQL高性能优化指南!35+条优化建议立马GET! | https://mp.weixin.qq.com/s/I-ZT3zGTNBZ6egS7T09jyQ |
| 后端程序员必备:书写高质量SQL的30条建议 | https://mp.weixin.qq.com/s?__biz=Mzg2OTA0Njk0OA==&mid=2247486461&idx=1&sn=60a22279196d084cc398936fe3b37772&chksm=cea24436f9d5cd20a4fa0e907590f3e700d7378b3f608d7b33bb52cfb96f503b7ccb65a1deed&token=1987003517&lang=zh_CN#rd |
|
| 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 |