|
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 - downloadIndex: T U k
Length: 9443 (0x24e3)
Types: TextFile
Notes: UNIX file
Names: »komm.sql.2«
└─⟦bee8f15db⟧ Bits:30004169/disk2.imd Uniplex II+ V.6 release 1.0 (dansk)
└─⟦bee8f15db⟧ UNIX Filesystem
└─⟦this⟧ »up/new/usr/UAP/outlines/quicklook/komm.sql.2«
V...T.......T.......T.......T.......T.......T.......T...........H
.FN
.SL58
.TM5
KOMMANDOOVERSIGT@@
BBBBBBBBBBBBBBBB
.BA2
.BM1
#@@
B
KOMMANDOOVERSIGT DATABASE SQL@@
BBBBBBBBBBBBBBBBBBBBBBBBBBBBB
V...T.......T.......T....H.VT.......T.......T.......T...........H
Afbryd q (quit)...........................479
Afslut database close database.....................441
Beskriv describe...........................455
Datofunktioner date...............................453
Ekstern kommando !<UNIX kommando>...................434
Fjern database drop database......................456
Fjern indeks drop index.........................457
Fjern tabel drop table.........................458
Fjern vis tabel drop view..........................459
Flyt paste..............................477
Forklarende tekster echo...............................460
Formater format.............................462
Fortryd transaktion rollback work......................485
Genbrug $..................................436
Genbrug $$.................................437
Hj▶91◀lp help...............................469
Inds▶91◀t insert.............................470
Kommentarlinie # <kommentar>......................435
L▶86◀s tabel lock table.........................475
Marker cut................................451
Nyt databasenavn rename database....................481
Nyt s▶9b◀jlenavn rename column......................480
Nyt tabelnavn rename table.......................482
Opdater update.............................515
Oph▶91◀v l▶86◀s p▶86◀ tabel unlock table.......................514
Oph▶91◀v rettighed revoke.............................483
Opret database create database....................443
Opret entydigt indeks create unique index................448
Opret indeks create index.......................444
Opret tabel create table.......................446
Opret vis tabel create view........................449
Opstart af database database d_navn....................474
Opstart af database invoke d_navn......................474
Retabler database rollforward database...............486
Sideopdeling page...............................476
Skriv write..............................518
Slet delete.............................454
Start database start database.....................511
Start transaktion begin work.........................440
Tildel rettigheder grant..............................466
Tilf▶9b◀j til en opgave append.............................439
Udf▶9b◀r transaktion commit work........................442
Use opgaver use................................517
V▶91◀lg select.............................487
V▶91◀lg union..............................512
▶92◀ndring af tabel alter table........................438
.FS
V......T........................................................H
SYNTAKSOVERSIGT DATABASE SQL@@
AAAAAAAAAAAAAAAAAAAAAAAAAAAA
!<UNIX kommando> ...........................................434
# <kommentar> ..............................................435
$$ .........................................................437
$$n ........................................................437
$$n-n ......................................................437
$n .........................................................436
$n-n .......................................................436
$n/gammel tekst/ny tekst ...................................436
alter table t_navn
{add (s_navn_ny <datatype> [before s_navn])|
drop (s_navn)|
modify (s_navn <datatype> [not null])} ..............438
append <opgavenavn>
{SELECT udsagn|USE udsagn|HISTORY udsagn} ...........439
begin work ...................................................440
close database .............................................441
commit work ................................................442
create database d_navn [with log in "<stinavn>"] ...........443
create index i_navn on t_navn (s_navn [asc|desc]
[,s_navn...]) .......................................444
create table t_navn (s_navn <datatype> [not null]
[,s_navn...]) [in "<katalog>"] ......................446
create unique index i_navn on t_navn (s_navn [asc|desc]
[,s_navn...]) .......................................448
create view v_navn [(s_navn,...)] as SELECT udsagn
[with check option] .................................449
cut <valgmulighed>
{SELECT udsagn|USE udsagn|HISTORY udsagn} ...........451
database d_navn ..............................................474
date .......................................................453
delete from t_navn [where s▶9b◀gekriterium] ...................454
describe database d_navn ...................................455
describe index i_navn ......................................455
describe table t_navn ......................................455
drop database d_navn .......................................456
drop index i_navn ..........................................457
drop table t_navn ..........................................458
drop view v_navn ...........................................459
echo <streng> ..............................................460
format column n date <streng> ..............................462
format column n dplaces <heltal> [trunc] ...................462
format column n header '<streng>' ..........................462
format column n width <heltal> .............................462
format column n zeros ......................................462
format end .................................................462
format end column n ........................................462
format header start ........................................462
format separator '<streng>' ................................462
format width <heltal> ......................................462
grant <db_rettighed> to {public|<brugerliste>} .............466
grant <rettighed> on t_navn to {public|<brugerliste>}
[with grant option] .................................466
help .......................................................469
help <emne> ................................................469
insert into t_navn [(s_navn,...)]
values (konstant[,...]) .............................470
insert into t_navn [(s_navn,...)]
{<SELECT udsagn>|<PASTE udsagn>} ....................472
invoke d_navn ..............................................474
lock table t_navn in {share|exclusive} mode ................475
page .......................................................476
page end ...................................................476
page n .....................................................476
paste ......................................................477
paste from <opgavenavn> ....................................477
paste from n ...............................................477
q (quit) ...................................................479
rename column t_navn.s_navn1 to s_navn2 ....................480
rename database d_navn1 to d_navn2 .........................481
rename table t_navn1 to t_navn2 ............................482
revoke <db_rettighed> from {public|<brugerliste>} ..........483
revoke <rettighed> on t_navn from {public|<brugerliste>} ...483
rollback work ..............................................485
rollforward database d_navn ................................486
select [distinct|all] {*|v▶91◀lgudtryk [,...]}
from t_navn [r_navn] [,tnavn...]
[group by s▶9b◀jle_udtryk [,...]]
[having s▶9b◀gekriterium]
[into temp t_navn]
[order by sorter_udtryk [asc|desc] [,sorter_u...]]
[where s▶9b◀gekriterium] ...............................487
where rowid = n ..................................499
where s_navn [not] like "streng" .................495
where s_navn [not] matches "streng" ..............495
where s_navn is [not] null .......................499
where udtryk [not] between udtryk and udtryk .....493
where udtryk [not] in (v▶91◀rdier) ..................494
where udtryk sammenligningsoperator [udtryk] .....493
SELECT udsagn union [all] SELECT udsagn [union...] .........512
select rowid, v▶91◀lg_udtryk from udtryk ......................499
start database d_navn with log in "<stinavn>" ..............511
unlock table t_navn ........................................514
update t_navn set s_navn = s▶9b◀jleudtryk [,s_navn...]
[where s▶9b◀gekriterium] ...............................515
use <opgavenavn> ...........................................517
write [append] <opgavenavn>
{SELECT udsagn|USE udsagn|HISTORY udsagn} ...........518
.FJ