Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create table student(
- STUDENT_ID NOT NULL INTEGER,
- SURENAME NOT NULL VARCHAR(15),
- NAME NOT NULL VARCHAR(15),
- STIPEND NOT NULL INTEGER,
- KURS NOT NULL INTEGER,
- CITY NOT NULL VARCHAR(15),
- BIRTHDAY NOT NULL TIMESTAMP(8),
- UNIV NOT NULL INTEGER,
- );
- INSERT INTO student VALUES (1,'Иванов','Иван',150,1,'Орел',1982123,10);
- INSERT INTO student VALUES (3,'Петров','Петр',200,3,'Курск',1980121,10);
- INSERT INTO student VALUES (6,'Сидоров','Вадим',150,4,'Москва',1979067,22);
- INSERT INTO student VALUES (10,'Кузнецов','Борис',0,2,'Брянск',1981128,10);
- INSERT INTO student VALUES (12,'Зайцева','Ольга',250,2,'Липецк',1981051,10);
- INSERT INTO student VALUES (265,'Павлов','Андрей',0,3,'Воронеж',1979115,10);
- INSERT INTO student VALUES (32,'Котов','Павел',150,5,'Белгород',NULL,14);
- INSERT INTO student VALUES (654,'Лукин','Артем',200,3,'Воронеж',1981121,10);
- INSERT INTO student VALUES (276,'Петров','Антон',200,4,NULL,1981085,22);
- INSERT INTO student VALUES (55,'Белкин','Вадим',250,5,'Воронеж',1980017,10);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement