Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE kniga (
- knigaID INT AUTO_INCREMENT,
- naslov VARCHAR(50) NOT NULL,
- avtor VARCHAR(50) DEFAULT 'Anonymous',
- izdavac VARCHAR(30),
- datumIzdavanje DATE,
- jazik VARCHAR(30),
- brojStrani INT,
- PRIMARY KEY(knigaID)
- );
- CREATE TABLE biblioteka (
- ime VARCHAR(50) UNIQUE,
- adresa VARCHAR(50),
- email VARCHAR(30),
- telBroj VARCHAR(9)
- );
- CREATE TABLE clen (
- clenID INT,
- ime VARCHAR(30),
- prezime VARCHAR(30),
- datumRagjanje DATE,
- datumZaclenuvanje DATE,
- PRIMARY KEY(clenID)
- );
- INSERT INTO kniga VALUES(1,'Crime and Punishment', 'Fyodor Dostoevsky', 'Penguin Classics', '1866-01-01', 'Russian', 671);
- INSERT INTO kniga VALUES(2,'To Kill a Mockingbird', 'Harper Lee', 'J.B. Lippincott & Co.', '1960-07-11', 'English', 281);
- INSERT INTO kniga VALUES(3,'1984', 'George Orwell', 'Secker & Warburg', '1949-06-08', 'English', 328);
- INSERT INTO kniga(naslov, avtor, izdavac, datumIzdavanje, jazik, brojStrani) VALUES('Zoki Poki', 'Olivera Nikolova', 'Antolog', '1995-11-07', 'Makedonski', 50);
- INSERT INTO kniga(naslov, avtor, izdavac, datumIzdavanje, jazik, brojStrani) VALUES('Doktor Ovboli', 'Антоан де Сент Егзипери', 'Antolog', '1865-12-05', 'Makedonski', 150);
- SELECT * FROM kniga;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement