|
DataMuseum.dkPresents historical artifacts from the history of: Regnecentalen RC-900 |
This is an automatic "excavation" of a thematic subset of
See our Wiki for more about Regnecentalen RC-900 Excavated with: AutoArchaeologist - Free & Open Source Software. |
top - metrics - download
Length: 6987 (0x1b4b)
Types: TextFile
Notes: UNIX file
Names: »quick.db.1«, »quick.db.4«
└─⟦bee8f15db⟧ Bits:30004169/disk2.imd Uniplex II+ V.6 release 1.0 (dansk)
└─⟦bee8f15db⟧ UNIX Filesystem
└─⟦this⟧ »up/new/usr/UAP/outlines/quicklook/quick.db.1«
└─⟦this⟧ »up/new/usr/UAP/outlines/quicklook/quick.db.4«
.PL43
L..T......T......T......T.......T.......T.......T....................................................................M
DATABASE QUICK REFERENCE CARD@@
HHHHHHHHHHHHHHHHHHHHHHHHHHHHH
.JN
.REF800
L..T......T......T......T.......T........R.L.........................................R.L.............................R
General Query Commands Setting Database Privileges Find Data@@
AAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAA
invoke database DATABASE_NAME grant PRIVILEGE to {public|USERLIST} SELECT CLAUSE@@
AAAAAAAAAAAAAAA AAAAA AA AAAAAA
FROM CLAUSE
close database revoke PRIVILEGE from {public|USERLIST} [WHERE CLAUSE]@@
AAAAAAAAAAAAAA AAAAAA AAAA AAAAAA
[GROUP BY CLAUSE]
quit Valid privileges: connect,resouce,dba [HAVING CLAUSE]@@
AAAA AAAAAAA AAAAAAA AAA
[ORDER BY CLAUSE]
echo STRING (Strings can include: Setting Table Privileges [INTO TEMP CLAUSE]@@
AAAA AAAAAAAAAAAAAAAAAAAAAAAA
\n, \t, \b, \r, \\, \x)
grant PRIVILEGE on TABLE_NAME SELECT CLAUSE:@@
AAAAA AA
Execute external commands !COMMAND to {public|USERLIST} [with grant option] select [all|distinct|unique]@@
A AA AAAAAA AAAAAAAAAAAAAAAAA AAAAAA AAA AAAAAAAA AAAAAA
Add comment lines #COMMENT [*|SELECT SPEC [SELECT SPEC..]]@@
A A
Recall last 100 statements $$ revoke PRIVILEGE on TABLE_NAME@@
AA AAAAAA AA
Recall series of statements $$N-M from {public|USERLIST} SELECT SPEC:@@
AA A AAAA AAAAAA
COLUMN_NAME|
Display help help Valid privileges: alter,delete,index TABLE_NAME.COLUMN_NAME|@@
AAAA AAAAA AAAAAA AAAAA
Display help on topic help TOPIC insert, select,update,all EXPRESSION@@
AAAA AAAAAA AAAAAA AAAAAA AAA
Setting Column Privileges FROM CLAUSE:@@
AAAAAAAAAAAAAAAAAAAAAAAAA
Build a Database from TABLE_NAME [,..]@@
AAAAAAAAAAAAAAAA AAAA
grant PRIVILEGE(COLUMN_NAME [, ...])@@
AAAAA A A
create database DATABASE_NAME on TABLE_NAME WHERE CLAUSE:@@
AAAAAAAAAAAAAAA AA
[with log in "FILENAME"] to {public|USERLIST} [with grant option] where CONDITION@@
AAAAAAAAAAA AA AAAAAA AAAAAAAAAAAAAAAAA AAAAA
create table TABLE_NAME (COLUMN_NAME Valid privileges: select,update GROUP BY CLAUSE:@@
AAAAAAAAAAAA A AAAAAA AAAAAA
TYPE ,...) [in directory_name]. group by COLUMN_NAME [, ...]@@
A AAAAAAAA
Types: char(N), integer, Add Information HAVING CLAUSE:@@
AAAAA A AAAAAAA AAAAAAAAAAAAAAA
decimal(m[,n]), date, having CONDITION@@
AAAAAAAA A AAAA AAAAAA
smallint, smallfloat, money, serial insert into TABLE_NAME@@
AAAAAAAA AAAAAAAAAA AAAAA AAAAAA AAAAAAAAAAA
[(COLUMN_NAME, COLUMN_NAME ...)] ORDER BY CLAUSE:@@
A A
create index INDEX_NAME on TABLE_NAME values (CONSTANT [,CONSTANT...]) order by COLUMN_NAME [asc|desc]@@
AAAAAAAAAAAA AAA AAAAAAAA A AAAAAAAA AAA AAAA
(COLUMN_NAME [asc|desc] [, ... ] ) [, ...]@@
A AAA AAAA A
insert into [(TABLE_NAME] paste@@
AAAAAAAAAAA I A AAAAA
from {FILENAME|N} INTO TEMP CLAUSE:@@
AAAA
into temp TEMPORARY_TABLE_NAME@@
AAAAAAAAA
insert into TABLE_NAME paste@@
AAAAAAAAAAA
SELECT STATEMENT
.JY
L..T......T......T......T.......T.......T.......T.................R............
Note: UPPERCASE denotes a variable, bold denotes an exact entry.@@
AAAA