reset password

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> | <Update> | <Create>
<Create> := <CreateTable> | <CreateView> | <CreateIndex>
   
<Insert> := INSERT INTO IdTok ( <FieldList> ) VALUES ( <ConstList> )
<FieldList> := <Field> [ , <FieldList> ]
<ConstList> := <Constant> [ , <ConstList> ]
   
<Delete> := DELETE FROM IdTok [ WHERE <Predicate> ]
   
<Update> := UPDATE IdTok SET <Field> = <Expression> [ WHERE <Predicate> ]
   
<CreateTable> := CREATE TABLE IdTok ( <FieldDefs> )
<FieldDefs> := <FieldDef> [ , <FieldDefs> ]
<FieldDef> := IdTok <TypeDef>
<TypeDef> := INT | VARCHAR ( IntTok )
   
<CreateView> := CREATE VIEW IdTok AS <Query>
   
<CreateIndex> := CREATE INDEX IdTok ON IdTok ( <Field> )

 

This page has been viewed 2020 times.