Advertisement
Guest User

Untitled

a guest
Oct 14th, 2019
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.68 KB | None | 0 0
  1. BEGIN TRANSACTION;
  2.  
  3. /* Create a table called NAMES */
  4. CREATE TABLE CHARACTER(Id integer PRIMARY KEY, Name text, int Age);
  5.  
  6. /* Create few records in this table */
  7. INSERT INTO CHARACTER VALUES(1,'Tom', 42);
  8. INSERT INTO CHARACTER VALUES(2,'Lucy', 65);
  9. INSERT INTO CHARACTER VALUES(3,'Frank', 5);
  10. INSERT INTO CHARACTER VALUES(4,'Jane', 20);
  11. INSERT INTO CHARACTER VALUES(5,'Robert', 37);
  12.  
  13. CREATE TABLE NAMES_SEXE(Id integer PRIMARY KEY, int Sexe);
  14.  
  15. /* Create few records in this table */
  16. INSERT INTO NAMES_SEXE VALUES(1, 0);
  17. INSERT INTO NAMES_SEXE VALUES(2, 1);
  18. INSERT INTO NAMES_SEXE VALUES(3, 0);
  19. INSERT INTO NAMES_SEXE VALUES(4, 1);
  20. INSERT INTO NAMES_SEXE VALUES(5, 0);
  21. COMMIT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement