"aaandmebaasidekindelkaust" - 1 õppematerjal

Andmebaasid

Toimumiskoht varchar(100), Alguskuupaev date not null, Loppkuupaev date) create table Partii( Id integer not null default autoincrement primary key, Turniir integer not null, Algushetk datetime not null default current timestamp, Lopphetk datetime, Valge integer not null, Must integer not null, Valge_tulemus smallint check (valge_tulemus in (0,1,2)), Musta_tulemus smallint check (musta_tulemus in (0,1,2)), Kokkuvote varchar(5000)) INPUT INTO Klubi FROM 'C:UsersRaunoDocumentsAAAndmebaasidekindelkaustopeklubi.txt' FORMAT ASCII DELIMITED BY 'x09'; INPUT INTO isik FROM 'C:UsersRaunoDocumentsAAAndmebaasidekindelkaustopeisik.txt' FORMAT ASCII DELIMITED BY 'x09' (id, eesnimi, perenimi, klubi); input into partii from 'C:UsersRaunoDocumentsAAAndmebaasidekindelkaustopepartii.txt' format ascii delimited by 'x09' (Turniir ,algushetk ,lopphetk ,valge,must,valge_tulemus,musta_tulemus); input into turniir FROM 'C:UsersRaunoDocumentsAAAndmebaasidekindelkaustopeturniir.txt'