|
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: 5392 (0x1510)
Types: TextFile
Notes: UNIX file
Names: »quick.db.2«
└─⟦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.2«
L.......T.......T.......T.......T.......T.......T.......T.......T.......M
DATABASE QUICK REFERENCE CARD@@
HHHHHHHHHHHHHHHHHHHHHHHHHHHHH
.JN
.REF800
L..T......T......T......T.......T........R.L.............................R
General Query Commands Find Data@@
AAAAAAAAAAAAAAAAAAAAAA AAAAAAAAA
invoke database DATABASE_NAME SELECT CLAUSE@@
AAAAAAAAAAAAAAA
FROM CLAUSE
close database [WHERE CLAUSE]@@
AAAAAAAAAAAAAA
[GROUP BY CLAUSE]
quit [HAVING CLAUSE]@@
AAAA
[ORDER BY CLAUSE]
echo STRING (Strings can include: [INTO TEMP CLAUSE]@@
AAAA
\n, \t, \b, \r, \\, \x)
SELECT CLAUSE:
Execute external commands !COMMAND select [all|distinct|unique]@@
A AAAAAA AAA AAAAAAAA AAAAAA
Add comment lines #COMMENT [*|SELECT SPEC [SELECT SPEC..]]@@
A A
Recall last 100 statements $$@@
AA
Recall series of statements $$N-M SELECT SPEC:@@
AA A
COLUMN_NAME|
Display help help TABLE_NAME.COLUMN_NAME|@@
AAAA
Display help on topic help TOPIC EXPRESSION@@
AAAA
FROM CLAUSE:
Build a Database from TABLE_NAME [,..]@@
AAAAAAAAAAAAAAAA AAAA
create database DATABASE_NAME WHERE CLAUSE:@@
AAAAAAAAAAAAAAA
[with log in "FILENAME"] where CONDITION@@
AAAAAAAAAAA AAAAA
create table TABLE_NAME (COLUMN_NAME GROUP BY CLAUSE:@@
AAAAAAAAAAAA A
TYPE ,...) [in directory_name]. group by COLUMN_NAME [, ...]@@
A AAAAAAAA
Types: char(N), integer, HAVING CLAUSE:@@
AAAAA A AAAAAAA
decimal(m[,n]), date, having CONDITION@@
AAAAAAAA A AAAA AAAAAA
smallint, smallfloat, money, serial@@
AAAAAAAA AAAAAAAAAA AAAAA AAAAAA
ORDER BY CLAUSE:
create index INDEX_NAME on TABLE_NAME order by COLUMN_NAME [asc|desc]@@
AAAAAAAAAAAA AAA AAAAAAAA AAA AAAA
(COLUMN_NAME [asc|desc] [, ... ] ) [, ...]@@
A AAA AAAA A
INTO TEMP CLAUSE:
Setting Database Privileges into temp TEMPORARY_TABLE_NAME@@
AAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAA
grant PRIVILEGE to {public|USERLIST}@@
AAAAA AA AAAAAA
revoke PRIVILEGE from {public|USERLIST} Add Information@@
AAAAAA AAAA AAAAAA AAAAAAAAAAAAAAA
Valid privileges: connect,resouce,dba insert into TABLE_NAME@@
AAAAAAA AAAAAAA AAA AAAAAAAAAAA
[(COLUMN_NAME,COLUMN_NAME ...)]@@
A A
Setting Table Privileges values (CONSTANT[,CONSTANT...])@@
AAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAA A
grant PRIVILEGE on TABLE_NAME insert into [(TABLE_NAME] paste@@
AAAAA AA AAAAAAAAAAA I A AAAAA
to {public|USERLIST} [with grant option] from {FILENAME|N}@@
AA AAAAAA AAAAAAAAAAAAAAAAA AAAA
revoke PRIVILEGE on TABLE_NAME insert into TABLE_NAME paste@@
AAAAAA AA AAAAAAAAAAA
from {public|USERLIST} SELECT STATEMENT@@
AAAA AAAAAA
Valid privileges: alter,delete,index@@
AAAAA AAAAAA AAAAA
insert, select,update,all@@
AAAAAA AAAAAA AAAAAA AAA
Setting Column Pr[Aileges@@
AAAAAAAAAAAAAAAAAAAAAAAAA
grant PRIVILEGE(COLUMN_NAME [, ...])@@
AAAAA A A
on TABLE_NAME@@
AA
to {public|USERLIST} [with grant option] Note: UPPERCASE denotes a@@
AA AAAAAA AAAAAAAAAAAAAAAAA
vaeriable, bold denotes an@@
AAAA
Valid privileges: select,update exact entry.@@
AAAAAA AAAAAA
.JY
L..T......T......T......T.......T.......T.......T.................R............