Guest User

Untitled

a guest
Jun 19th, 2018
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. id firstname gender
  2. 1 Aaron m
  3. 2 Adam m
  4. 3 Alan m
  5. etc...
  6.  
  7. SELECT id, firstname FROM firstname WHERE id = round(1 + (rand() * 199));
  8.  
  9. id firstname
  10. 43 Jason
  11.  
  12. -- First Name --
  13. drop table if exists firstname;
  14.  
  15. CREATE TABLE firstname (
  16. id INT NOT NULL,
  17. firstname VARCHAR(20) NOT NULL,
  18. gender VARCHAR(1) NOT NULL,
  19. PRIMARY KEY (id),
  20. UNIQUE (firstname)
  21. );
  22.  
  23. INSERT INTO firstname
  24. (id,firstname,gender)
  25. VALUES
  26. (1,"Aaron","m"),
  27. (2,"Adam","m"),
  28. (3,"Alan","m"),
  29. (4,"Albert","m"),
  30. (5,"Alexander","m"),
  31. (6,"Andrew","m"),
  32. (7,"Anthony","m"),
  33. (8,"Arthur","m"),
  34. (9,"Austin","m"),
  35. (10,"Benjamin","m"),
  36. (11,"Billy","m"),
  37. (12,"Bobby","m"),
  38. (13,"Brandon","m"),
  39. (14,"Brian","m"),
  40. (15,"Bruce","m"),
  41. (16,"Bryan","m"),
  42. (17,"Carl","m"),
  43. (18,"Charles","m"),
  44. (19,"Christian","m"),
  45. (20,"Christopher","m");
Add Comment
Please, Sign In to add comment