Show Table of Contents
A.6. Production Cross-Reference
|
Name
|
Usage
|
|---|---|
|
add set option
|
alter options list
|
|
standard aggregate function
|
unsigned value expression primary
|
|
all in group
|
select sublist
|
|
alter
|
directly executable statement
|
|
alter column options
|
alter options
|
|
alter options list
|
alter column options , alter options
|
|
alter options
|
ddl statement
|
|
analytic aggregate function
|
unsigned value expression primary
|
|
array table
|
table primary
|
|
assignment statement
|
delimited statement
|
|
assignment statement operand
|
assignment statement , declare statement
|
|
between predicate
|
boolean primary
|
|
boolean primary
|
filter clause , boolean factor
|
|
branching statement
|
delimited statement
|
|
case expression
|
unsigned value expression primary
|
|
character
|
match predicate , text aggregate function , text table
|
|
column list
|
other constraints , create temporary table , foreign key , insert statement primary key , with list element
|
|
common value expression
|
between predicate , boolean primary , comparison predicate , sql exception , match predicate , like regex predicate , in predicate , text table , unsigned value expression primary
|
|
comparison predicate
|
boolean primary
|
|
boolean term
|
boolean value expression
|
|
boolean value expression
|
condition
|
|
compound statement
|
statement
|
|
other constraints
|
create table body
|
|
table element
|
create table body
|
|
create procedure
|
ddl statement
|
|
typed element list
|
array table , dynamic data statement
|
|
create foreign temp table
|
directly executable statement
|
|
option namespace
|
ddl statement
|
|
create table
|
ddl statement
|
|
create table body
|
create foreign temp table , create table
|
|
create temporary table
|
directly executable statement
|
|
create trigger
|
ddl statement , directly executable statement
|
|
condition
|
expression , having clause , if statement , qualified table , searched case expression , where clause , while statement
|
|
cross join
|
joined table
|
|
declare statement
|
delimited statement
|
|
delete statement
|
assignment statement operand , directly executable statement
|
|
delimited statement
|
statement
|
|
derived column
|
derived column list , object table , querystring function , text aggregate function , xml attributes , xml query , xml table
|
|
derived column list
|
json object , xml forest
|
|
drop option
|
alter options list
|
|
drop table
|
directly executable statement
|
|
dynamic data statement
|
data statement
|
|
raise error statement
|
delimited statement
|
|
sql exception
|
assignment statement operand , exception reference
|
|
exception reference
|
sql exception , raise statement
|
|
named parameter list
|
call statement
|
|
exists predicate
|
boolean primary
|
|
expression
|
standard aggregate function , assignment statement operand , case expression , derived column , dynamic data statement , raise error statement , named parameter list , expression list , function , object table column , ordered aggregate function , querystring function , return statement , searched case expression , select derived column , set clause list , sort key , unsigned value expression primary , xml table column , xml element , xml parse , xml serialize
|
|
expression list
|
callable statement , other constraints , function , group by clause , insert statement , call statement , window specification
|
|
fetch clause
|
limit clause
|
|
filter clause
|
function , unsigned value expression primary
|
|
for each row trigger action
|
alter , create trigger
|
|
foreign key
|
create table body
|
|
from clause
|
query
|
|
function
|
unsigned value expression primary
|
|
group by clause
|
query
|
|
having clause
|
query
|
|
identifier
|
alter , alter column options , alter options , array table , assignment statement , branching statement , callable statement , column list , compound statement , table element , create procedure , typed element list , create foreign temp table , option namespace , create table , create table body , create temporary table , create trigger , declare statement , delete statement , derived column , drop option , drop table , dynamic data statement , exception reference , named parameter list , foreign key , function , insert statement , into clause , loop statement , xml namespace element , object table column , object table , option clause , option pair , procedure parameter , procedure result column , query primary , select derived column , set clause list , statement , call statement , table subquery , temporary table element , text aggregate function , text table column , text table , table name , update statement , with list element , xml table column , xml element , xml serialize , xml table
|
|
if statement
|
statement
|
|
insert statement
|
assignment statement operand , directly executable statement
|
|
integer parameter
|
fetch clause , limit clause
|
|
unsigned integer
|
dynamic data statement , integer parameter , data type , text table column , text table , unsigned value expression primary
|
|
time interval
|
function
|
|
into clause
|
query
|
|
is null predicate
|
boolean primary
|
|
joined table
|
table primary , table reference
|
|
json object
|
function
|
|
limit clause
|
query expression body
|
|
loop statement
|
statement
|
|
match predicate
|
boolean primary
|
|
xml namespace element
|
xml namespaces
|
|
non numeric literal
|
option pair , value expression primary
|
|
non-reserved identifier
|
identifier , unsigned value expression primary
|
|
boolean factor
|
boolean term
|
|
object table column
|
object table
|
|
object table
|
table primary
|
|
comparison operator
|
comparison predicate , quantified comparison predicate
|
|
option clause
|
callable statement , delete statement , insert statement , query expression body , call statement , update statement
|
|
option pair
|
add set option , options clause
|
|
options clause
|
table element , create procedure , create table , create table body , procedure parameter , procedure result column
|
|
order by clause
|
function , ordered aggregate function , query expression body , text aggregate function , window specification
|
|
ordered aggregate function
|
unsigned value expression primary
|
|
data type
|
table element , create procedure , typed element list , declare statement , function , object table column , procedure parameter , procedure result column , temporary table element , text table column , xml table column
|
|
numeric value expression
|
common value expression
|
|
plus or minus
|
option pair , numeric value expression , value expression primary
|
|
primary key
|
create table body
|
|
procedure parameter
|
create procedure
|
|
procedure result column
|
create procedure
|
|
qualified table
|
joined table
|
|
query
|
query primary
|
|
query expression
|
alter , assignment statement operand , create table , insert statement , loop statement , subquery , table subquery , directly executable statement , with list element
|
|
query expression body
|
query expression , query primary
|
|
query primary
|
query term
|
|
querystring function
|
function
|
|
query term
|
query expression body
|
|
raise statement
|
delimited statement
|
|
like regex predicate
|
boolean primary
|
|
return statement
|
delimited statement
|
|
searched case expression
|
unsigned value expression primary
|
|
select clause
|
query
|
|
select derived column
|
select sublist
|
|
select sublist
|
select clause
|
|
set clause list
|
dynamic data statement , update statement
|
|
in predicate
|
boolean primary
|
|
sort key
|
sort specification
|
|
sort specification
|
order by clause
|
|
data statement
|
delimited statement
|
|
statement
|
alter , compound statement , create procedure , for each row trigger action , if statement , loop statement , procedure body definition , while statement
|
|
call statement
|
assignment statement , subquery , table subquery , directly executable statement
|
|
string
|
character , table element , option namespace , function , xml namespace element , non numeric literal , object table column , object table , procedure parameter , text table column , text table , xml table column , xml query , xml serialize , xml table
|
|
subquery
|
exists predicate , in predicate , quantified comparison predicate , unsigned value expression primary
|
|
quantified comparison predicate
|
boolean primary
|
|
table subquery
|
table primary
|
|
temporary table element
|
create temporary table
|
|
table primary
|
cross join , joined table
|
|
table reference
|
from clause , qualified table
|
|
text aggregate function
|
unsigned value expression primary
|
|
text table column
|
text table
|
|
text table
|
table primary
|
|
term
|
numeric value expression
|
|
star or slash
|
term
|
|
table name
|
table primary
|
|
unsigned numeric literal
|
option pair , value expression primary
|
|
unsigned value expression primary
|
value expression primary
|
|
update statement
|
assignment statement operand , directly executable statement
|
|
directly executable statement
|
data statement
|
|
value expression primary
|
array table , term
|
|
where clause
|
delete statement , query , update statement
|
|
while statement
|
statement
|
|
window specification
|
unsigned value expression primary
|
|
with list element
|
query expression
|
|
xml attributes
|
xml element
|
|
xml table column
|
xml table
|
|
xml element
|
function
|
|
xml forest
|
function
|
|
xml namespaces
|
xml element , xml forest , xml query , xml table
|
|
xml parse
|
function
|
|
xml query
|
function
|
|
xml serialize
|
function
|
|
xml table
|
table primary
|

Where did the comment section go?
Red Hat's documentation publication system recently went through an upgrade to enable speedier, more mobile-friendly content. We decided to re-evaluate our commenting platform to ensure that it meets your expectations and serves as an optimal feedback mechanism. During this redesign, we invite your input on providing feedback on Red Hat documentation via the discussion platform.