Andmebaasid
CREATE TABLE mina (
eesnimi varchar(30) not null,
perenimi varchar(100) not null,
sugu varchar(5) not null,
synnipaev date not null,
algus datetime not null default current timestamp,
viimati datetime default timestamp,
CONSTRAINT pk_mina PRIMARY KEY (eesnimi)
);
INSERT INTO mina
(eesnimi, perenimi, sugu, synnipaev)
VALUES ('Juku', 'Mets', 'Mees', '1980-02-04');
grant connect to Sandra identified by 'tere';
grant group to dba;
grant membership in group dba to Sandra;
grant all on mina to Sandra;
SELECT * FROM mina;
UPDATE mina SET eesnimi = 'Jri'
WHERE eesnimi = 'Juku';
CREATE GLOBAL TEMPORARY TABLE paha (nimi
VARCHAR(40) NOT NULL, CONSTRAINT pk_paha
PRIMARY KEY (nimi)) ON COMMIT PRESERVE
ROWS;
INSERT INTO paha (nimi) VALUES ('Mari');
SELECT * FROM paha;
create table isik(
Id integer not null default autoincrement primary key,
Eesnimi varchar (50) not null,
Perenimi varchar(50) not null,
Isikukood varchar(11),
Klubi integer,
U...
annaabi.ee 
