Quizmaker
You may
- enter a new database file name to create a .pdb file
- enter you previously created database name to edit a .pdb file
All new or editable filenames must contain the word "test" preceded and/or followed by your identifier.
Extension code is added automatically.
|
You may also select an existing quizfile to check and learn the structure of quiz files:
pres
usstates
enking
franking
romans
makir
maime
torme
After entering a name or selection click on the appropriate button.
SELECT [ DISTINCT ] * | columnlist
FROM source
[ [ LEFT | RIGHT | FULL ] INNER | OUTER JOIN source
ON t1.column == t2.column ]
[ WHERE condition
] [ ORDER BY columnlist
ASC | DESC ]
INSERT INTO table COLUMNS
{ ( columnlist
) VALUES ( valuelist
) } | { [( columnlist
)] AS source
}
UPDATE TABLE table { SET column
= value
, .... WHERE condition
} | { AS keylist
source
}
DELETE FROM table { WHERE condition
} | { AS keylist
source
}
ALTER TABLE table [ ADD columnlist
] [ DROP columnlist
]
CREATE TABLE | VIEW table { ( columnlist
) } | { [( columnlist
)] AS source
}
DROP table
Nonstandard : CHECK table
source
: table filename | full ( SELECT command ) inside parentheses | source
AS alias
columnlist
: column
definition list separated comma
keylist
: columnlist
of keys for identification purposes
valuelist
: comma separated list of value
entries
condition
: perl logical expression
(column names substituted by row value)
command words : all capital letters, has to be written as the are
filling words : may be written as they are, those are skipped before analysis
column
definition : name of a column
| name of a table . name of a column
| expression
| aggregate
| column
AS alias
value
: scalar
or expression
scalar
: number | 'string'| '/regular expression/.' immediatelly after =~ or !~ operator
expression
: perl expression
where column
names will be substituted by raw value.
aggregate
: function
( column
name or expression
[ AS alias ] ) [ GROUP BY column
name or expression
[ AS alias] ]
function
: COUNT | AVG | SUM | MIN | MAX | RANK followed by columnname or expression
enclosed into ( ) parenteses
AS keyword is used as :
- note alias in column
definition
- note alias in source
definition for decoration purposes
- note keylist
in the variation of UPDATE or DELETE
- note source
in the variation of CREATE or INSERT
Back to main index
|