SHARE
TWEET

Untitled

a guest May 23rd, 2019 103 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. -- First, remove the table if it exists
  2. drop table if exists bookmarks;
  3.  
  4. -- Create the table anew
  5. create table bookmarks (
  6.   id INTEGER primary key generated by default as identity,
  7.   bookName text,
  8.   page INT(4)
  9. );
  10.  
  11. -- insert some test data
  12. -- Using a multi-row insert statement here
  13. insert into bookmarks (bookName, page)
  14. values
  15.   ('The Lord of the Rings: The Return of the King', 75),
  16.   ('Don Quixote', 213),
  17.   ('A Man Called Ove', 12),
  18.   ('Pride and Prejudice', 150),
  19.   ('Olympos', 52),
  20.   ('Feed', 79),
  21.   ('Good Omens', 112),
  22.   ('Discworld', 49),
  23.   ('Creepers', 3),
  24.   ('Greybeard', 101),
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top