| Both sides previous revisionPrevious revisionNext revision | Previous revision |
| spec [2012/03/01 13:56] – wuyw | spec [2012/03/10 15:08] (current) – old revision restored wuyw |
|---|
| - Support transaction | - Support transaction |
| - Logger and roll back | - Logger and roll back |
| - Supplementary Speci cation | - Supplementary Specifi cation |
| - Syntax | - Syntax |
| - STRING & DATE | - STRING & DATE |
| *DROP TABLE //tbl-name// [,//tbl-name//] | *DROP TABLE //tbl-name// [,//tbl-name//] |
| *//create-definition// ::= //column-definition// | PRIMARY KEY (//col-name//) | *//create-definition// ::= //column-definition// | PRIMARY KEY (//col-name//) |
| *//column-definition// ::= //col-name// //data-type// [[Not]NULL] [DEFAULT //const-value//][AUTO_INCREMENT] | *//column-definition// ::= //col-name// //data-type// [[NOT]NULL] [DEFAULT //const-value//][AUTO_INCREMENT] |
| *//data-type// ::= INT | FLOAT | CHAR(M) | DATETIME | BOOLEAN | DECIMAL(M[,D]) | TIMESTAMP | VARCHAR(M) | *//data-type// ::= INT | FLOAT | CHAR(M) | DATETIME | BOOLEAN | DECIMAL(M[,D]) | TIMESTAMP | VARCHAR(M) |
| |
| - Select | - Select |
| | |
| *SELECT [DISTINCT] //select-expr//,...\\ [FROM //tbl-ref//[,//tbl-ref//]...]\\ [WHERE //where-condition//]\\ [GROUP BY //col-name//]\\ [HAVING //having-condition//]\\ [ORDERE BY col-name[ ASC | DESC ],...] | *SELECT [DISTINCT] //select-expr//,...\\ [FROM //tbl-ref//[,//tbl-ref//]...]\\ [WHERE //where-condition//]\\ [GROUP BY //col-name//]\\ [HAVING //having-condition//]\\ [ORDER BY col-name[ ASC | DESC ],...] |
| *//select-expr// ::=//value// [AS //alias//]|* | *//select-expr// ::=//value// [AS //alias//]|* |
| *//func// ::= AVG | COUNT | MIN | MAX | SUM | *//func// ::= AVG | COUNT | MIN | MAX | SUM |
| *//where-condition//::=//bool-expr// | *//where-condition//::=//bool-expr// |
| *//bool-expr// ::=//value cop value// \\ | //bool-expr// AND //bool-expr// \\ | //bool-expr// OR //bool-expr// \\ | [NOT] EXISTS (//subquery//)\\ | //value cop// ANY (//subquery//) \\ | //value// IN (//subquery//) \\ | //value cop// ALL (//subquery//) \\ | (//bool-expr//) | *//bool-expr// ::=//value cop value// \\ | //bool-expr// AND //bool-expr// \\ | //bool-expr// OR //bool-expr// \\ | [NOT] EXISTS (//subquery//)\\ | //value cop// ANY (//subquery//) \\ | //value// IN (//subquery//) \\ | //value cop// ALL (//subquery//) \\ | (//bool-expr//) |
| *//cop// ::= < | > | = | >= | >= | <> | *//cop// ::= < | > | = | ''''<''='' | >= | <> |
| *//value// ::= (//value//)|//col-name//|//const-value//|//value aop value// \\ | (subquery with only one elements(or NULL)in the result table)\\ | //func//(//col-name//) | *//value// ::= (//value//)|//col-name//|//const-value//|//value aop value// \\ | (subquery with only one elements(or NULL)in the result table)\\ | //func//(//col-name//) |
| *//aop// ::= + | - | * | / | % | *//aop// ::= + | - | * | / | % |
