Grammar for SimpleDB's Subset of SQL
| <Field> |
:= IdTok |
| <Constant> |
:= StrTok | IntTok |
| <Expression> |
:= <Field> | <Constant> |
| <Term> |
:= <Expression> = <Expression> |
| <Predicate> |
:= <Term> [ AND <Predicate> ] |
| |
|
| <Query> |
:= SELECT <SelectList> FROM <TableList> [ WHERE <Predicate> ] |
| <SelectList> |
:= <Field> [ , <SelectList> ] |
| <TableList> |
:= IdTok [ , <TableList> ] |
| |
|
| <UpdateCmd> |
:= <Insert> | <Delete> | <Modify> | <Create> |
| <Create> |
:= <CreateTable> | <CreateView> | <CreateIndex> |
| |
|
| <Insert> |
:= INSERT INTO IdTok ( <FieldList> ) VALUES ( <ConstList> ) |
| <FieldList> |
:= <Field> [ , <FieldList> ] |
| <ConstList> |
:= <Constant> [ , <ConstList> ] |
| |
|
| <Delete> |
:= DELETE FROM IdTok [ WHERE <Predicate> ] |
| |
|
| <Modify> |
:= UPDATE IdTok SET <Field> = <Expression> [ WHERE <Predicate> ] |
| |
|
| <CreateTable> |
:= CREATE TABLE IdTok ( <FieldDefs> ) |
| <FieldDefs> |
:= <FieldDef> [ , <FieldDefs> ] |
| |
|
|
This page has been viewed 2441 times.
