Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- BEGIN TRANSACTION;
- /* Create a table called NAMES */
- CREATE TABLE CHARACTER(Id integer PRIMARY KEY, Name text, int Age);
- /* Create few records in this table */
- INSERT INTO CHARACTER VALUES(1,'Tom', 42);
- INSERT INTO CHARACTER VALUES(2,'Lucy', 65);
- INSERT INTO CHARACTER VALUES(3,'Frank', 5);
- INSERT INTO CHARACTER VALUES(4,'Jane', 20);
- INSERT INTO CHARACTER VALUES(5,'Robert', 37);
- CREATE TABLE NAMES_SEXE(Id integer PRIMARY KEY, int Sexe);
- /* Create few records in this table */
- INSERT INTO NAMES_SEXE VALUES(1, 0);
- INSERT INTO NAMES_SEXE VALUES(2, 1);
- INSERT INTO NAMES_SEXE VALUES(3, 0);
- INSERT INTO NAMES_SEXE VALUES(4, 1);
- INSERT INTO NAMES_SEXE VALUES(5, 0);
- COMMIT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement