没有合适的资源?快使用搜索试试~ 我知道了~
首页MySQL开发者SQL权威指南:附录深入解析
MySQL开发者SQL权威指南的附录详细探讨了SQL语法及其在数据库管理中的应用。首先,附录A以简洁的介绍引领读者进入SQL语法规则的世界,强调了本附录与之前章节的区别,即提供完整而非简化版本的语句定义,以便于理解和查阅。 附录的核心内容是BNF范式,这是SQL语法描述的一种标准化形式,源于巴科斯-诺尔范式(BNF),这是一种用于描述编程语言和计算机科学语言结构的正式表示法。它通过替换规则和生成规则组织语言,将SQL语句划分为终结符(如关键字CLOSE和分号)和非终结符(如<selectstatement>和<tablereference>),后者由其他符号通过生成规则定义。 尖括号<>用于表示非终结符,每个非终结符都有其特定的生成规则,如<closecursorstatement>的定义为CLOSE<cursorname>,表明一个关闭游标语句由一个关闭操作和后续游标名称组成。"|”符号用于表示选择性,例如在<character>的定义中,可以是一个数字字符<digi"。 整个附录不仅提供了SQL语句的精确语法结构,还对元符号如<>、::=和|等进行了深入解析,这对于MySQL开发者来说,是理解和编写高效、规范SQL查询的重要参考资料。通过学习这部分内容,开发者能够更好地掌握SQL语法规则,避免在实际开发过程中遇到困扰,提升数据库管理的效率和准确性。
资源详情
资源推荐
Drop User语句
<drop user statement> ::=
DROP USER <user name> [ , <user name> ]...
Drop View语句
<drop view statement> ::=
DROP VIEW [ IF EXISTS ] <table specification>
[ , <table specification> ]...
[ RESTRICT | CASCADE ]
Execute语句
<execute statement> ::=
EXECUTE <statement name>
[ USING <user variable> [ , <user variable>]... ]
Fetch Cursor语句
<fetch cursor statement> ::=
FETCH <cursor name>
INTO <local variable> [ , <local variable> ]...
Grant语句
<grant statement> ::=
<grant table privilege statement> |
<grant database privilege statement> |
<grant user privilege statement> |
<grant execute privilege statement>
<grant table privilege statement> ::=
GRANT <table privileges>
ON <table specification>
TO <grantees>
[ WITH <grant option>... ]
<grant database privilege statement> ::=
GRANT <database privileges>
ON [ <database name> . ] *
TO <grantees>
[ WITH <grant option>... ]
<grant user privilege statement> ::=
GRANT <user privileges>
ON *.*
TO <grantees>
[ WITH <grant option>... ]
<grant execute privilege statement> ::=
GRANT EXECUTE
610
附录
ON { PROCEDURE <stored procedure name> |
FUNCTION <stored function name> }
TO <grantees>
[ WITH <grant option>... ]
Handler Close语句
<handler close statement> ::=
HANDLER <handler name> CLOSE
Handler Open语句
<handler open statement> ::=
HANDLER <table specification> OPEN [ As <handler name> ]
Handler Read语句
<handler read statement> ::=
HANDLER <handler name> READ <read specification>
[ <where clause> ]
[ <limit clause> ]
<read specification> ::=
FIRST |
NEXT |
{ <index name> { FIRST | NEXT | PREV | LAST } } |
{ <index name> { = | > | >= | <= | < }
<scalar expression list> }
Help语句
<help statement> ::=
HELP <alphanumeric literal>
If语句
<if statement> ::=
IF <condition> THEN <statement list>
[ ELSEIF <condition> THEN <statement list>]...
[ ELSE <statement list> ]
END IF
Insert语句
<insert statement> ::=
INSERT [ DELAYED | LOW_PRIORITY | HIGH_PRIORITY ]
[ IGNORE ] [ INTO ] <table specification>
<insert specification> [ <on duplicate key specification> ]
<on duplicate key specification> ::=
ON DUPLICATE KEY UPDATE <column assignment>
[ , <column assignment> ]...
附录
A SQL
语法
611
Iterate语句
<iterate statement> ::=
ITERATE <label>
Leave语句
<leave statement> ::=
LEAVE <label>
Load语句
<load statement> ::=
LOAD DATA [ LOW_PRIORITY ] [ CONCURRENT ] [ LOCAL ]
INFILE '<file name>'
[ REPLACE | IGNORE ]
INTO TABLE <table specification>
[ <fields specification> ]
[ <lines specification> ]
[ IGNORE <whole number> LINES ]
[ { <column name> | <user variable> }
[ , { <column name> | <user variable> } ]... ]
[ <set statement> ]
<fields specification> ::=
FIELDS [ TERMINATED BY <alphanumeric literal> ]
[ [ OPTIONALLY ] ENCLOSED BY <alphanumeric literal> ]
[ ESCAPED BY <alphanumeric literal> ]
<lines specification> ::=
LINES [ TERMINATED BY <alphanumeric literal> ]
[ STARTING BY <alphanumeric literal> ]
Lock Table语句
<lock table statement> ::=
LOCK { TABLE | TABLES } <lock table> [ ,<lock table> ]...
<lock table> ::=
<table specification> [ AS <pseudonym> ]<lock type>
<lock type> ::= READ | READ LOCAL | WRITE |LOW_PRIORITY WRITE
Loop语句
<loop statement> ::=
[ <label> : ] LOOP <statement list>
END LOOP [ <label> ]
Open Cursor语句
<open cursor statement> ::=
OPEN <cursor name>
612
附录
Optimize Table语句
<optimize table statement> ::=
OPTIMIZE [ <optimize option> ]
TABLE <table specification> [ , <table specification> ]...
<optimize option> ::= NO_WRITE_TO_BINLOG | LOCAL
Prepare语句
<prepare statement> ::=
PREPARE <statement name>
FROM { <alphanumeric literal> | <user variable> }
Rename Table语句
<rename table statement> ::=
RENAME { TABLE | TABLES } <table name change>
[ , <table name change> ]...
<table name change> ::= <table name> TO <table name>
Rename User语句
<rename user statement> ::=
RENAME USER <user name> TO <user name>
[ , <user name> TO <user name> ]...
Repair Table语句
<repair table statement> ::=
REPAIR [ <repair option> ]
TABLE <table specification> [ , <table specification> ]...
[ QUICK ] [ EXTENDED ] [ USE_FRM ]
<repair option> ::= NO_WRITE_TO_BINLOG | LOCAL
Repeat语句
<repeat statement> ::=
[ <label> : ] REPEAT <statement list>
UNTIL <condition>
END REPEAT <label>
Replace语句
<replace statement> ::=
REPLACE [ DELAYED | LOW_PRIORITY] [ IGNORE ]
[ IGNORE ] [ INTO ] <table specification>
<insert specification>
Restore Table语句
<restore table statement> ::=
RESTORE TABLE <table specification>
附录
A SQL
语法
613
剩余84页未读,继续阅读
ustceeer
- 粉丝: 0
- 资源: 16
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- 最优条件下三次B样条小波边缘检测算子研究
- 深入解析:wav文件格式结构
- JIRA系统配置指南:代理与SSL设置
- 入门必备:电阻电容识别全解析
- U盘制作启动盘:详细教程解决无光驱装系统难题
- Eclipse快捷键大全:提升开发效率的必备秘籍
- C++ Primer Plus中文版:深入学习C++编程必备
- Eclipse常用快捷键汇总与操作指南
- JavaScript作用域解析与面向对象基础
- 软通动力Java笔试题解析
- 自定义标签配置与使用指南
- Android Intent深度解析:组件通信与广播机制
- 增强MyEclipse代码提示功能设置教程
- x86下VMware环境中Openwrt编译与LuCI集成指南
- S3C2440A嵌入式终端电源管理系统设计探讨
- Intel DTCP-IP技术在数字家庭中的内容保护
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功