Advertisement
Guest User

Untitled

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