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