Advertisement
Guest User

Untitled

a guest
Dec 18th, 2014
146
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.18 KB | None | 0 0
  1. SELECT
  2. univ._id,
  3. univ.firstName,
  4. univ.lastName,
  5. univ.status,
  6. univ.veikla,
  7. univ.cellPhone,
  8. univ.homePhone
  9. FROM universitetas univ
  10.  
  11. <sql>
  12. <statement>
  13. CREATE TABLE IF NOT EXISTS universitetas (
  14. _id INTEGER PRIMARY KEY AUTOINCREMENT,
  15. firstName VARCHAR(50),
  16. lastName VARCHAR(50),
  17. status VARCHAR(50),
  18. veikla VARCHAR(50),
  19. city VARCHAR(50),
  20. cellPhone VARCHAR(30),
  21. homePhone VARCHAR(30),
  22. email VARCHAR(30))
  23. </statement>
  24. <statement>INSERT INTO universitetas VALUES(1,'Martin','Tubis','Studentas','Pirmas kursas', 'Vilnius','+370 654 09353','242 74 03','martintubis@gmail.com')</statement>
  25. <statement>INSERT INTO universitetas VALUES(2,'Petras','Petraitis','Studentas','Pirmas kursas','Vilnius', '+370 654 09463','222 76 43','petrapetratis@gmail.com')</statement>
  26. <statement>INSERT INTO universitetas VALUES(3,'Jonas','Jonaitis','Destytojas','Matematikos destytojas','Vilnius','+370 654 09853','246 65 63','jonasjonaitis@gmail.com')</statement>
  27. <statement>INSERT INTO universitetas VALUES(4,'Darius','Petraitis','Dekanas','Dekanatas','Vilnius', '+370 654 12453','248 65 26','dariuspetraitis@gmail.com')</statement>
  28. <statement>INSERT INTO universitetas VALUES(5,'Simonas','Daukantas','Destytojas','Programavimo destytojas','Vilnius','+370 654 09634','265 34 73','simonasdaukantas@gmail.com')</statement>
  29. <statement>INSERT INTO universitetas VALUES(6,'Linas','Kleiza','Studentas','Antras kursas','Vilnius','+370 654 34553','231 65 73','linaskleiza@gmail.com')</statement>
  30. <statement>INSERT INTO universitetas VALUES(7,'Robertas','Javtokas','Studentas','Trecias kursas', 'Vilnius','+370 654 13562','213 88 43','robertasjavtokas@gmail.com')</statement>
  31. <statement>INSERT INTO universitetas VALUES(8,'Oscar','Whilde','Prodekanas','Dekanatas', 'Vilnius','+370 654 46434','216 45 63','oscarwhilde@gmail.com')</statement>
  32. <statement>INSERT INTO universitetas VALUES(9,'James','Cameron','Studentas','Antras kursas', 'Vilnius','+370 654 99453','216 81 83','jamescameron@gmail.com')</statement>
  33. <statement>INSERT INTO universitetas VALUES(10,'Bred','Pitt','Studentas','Pirmas kursas', 'Vilnius','+370 654 06783','266 66 66','bredpitt@gmail.com')</statement>
  34. </sql>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement