SHARE
TWEET

Untitled

a guest Apr 26th, 2019 102 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. mysql> SELECT firstname, lastname, birthday FROM wizard ORDER BY birthday ASC LIMIT 0,1;
  2. +-----------+------------+------------+
  3. | firstname | lastname   | birthday   |
  4. +-----------+------------+------------+
  5. | albus     | dumbledore | 1881-07-01 |
  6. +-----------+------------+------------+
  7.  
  8. mysql> SELECT * FROM wizard WHERE lastname='Potter' ORDER BY firstname ASC;
  9. +----+-----------+----------+------------+-------------+------------------------+-----------+
  10. | id | firstname | lastname | birthday   | birth_place | biography              | is_muggle |
  11. +----+-----------+----------+------------+-------------+------------------------+-----------+
  12. | 29 | harry     | potter   | 1980-07-31 | london      |                        |         0 |
  13. | 31 | lily      | potter   | 1960-01-30 |             | mother of Harry Potter |         0 |
  14. +----+-----------+----------+------------+-------------+------------------------+-----------+
  15.  
  16. mysql> SELECT * FROM wizard ORDER BY firstname ASC LIMIT 2 OFFSET 21;
  17. +----+-----------+----------+------------+-------------+------------------------+-----------+
  18. | id | firstname | lastname | birthday   | birth_place | biography              | is_muggle |
  19. +----+-----------+----------+------------+-------------+------------------------+-----------+
  20. | 29 | harry     | potter   | 1980-07-31 | london      |                        |         0 |
  21. | 30 | hermione  | granger  | 1979-09-19 |             | Friend of Harry Potter |         0 |
  22. +----+-----------+----------+------------+-------------+------------------------+-----------+
  23.  
  24. mysql> SELECT * FROM wizard WHERE birthday BETWEEN '1975-01-01' AND '1985-01-01';
  25. +----+-----------+----------+------------+-------------+---------------------------------------+-----------+
  26. | id | firstname | lastname | birthday   | birth_place | biography                             | is_muggle |
  27. +----+-----------+----------+------------+-------------+---------------------------------------+-----------+
  28. |  4 | ron       | weasley  | 1980-03-01 |             | Best friend of Harry                  |         0 |
  29. |  5 | ginny     | weasley  | 1981-08-11 |             | Sister of Ron and girlfriend of Harry |         0 |
  30. |  6 | fred      | weasley  | 1978-04-01 |             |                                       |         0 |
  31. |  7 | george    | weasley  | 1978-04-01 |             |                                       |         0 |
  32. | 10 | drago     | malefoy  | 1980-06-05 |             |                                       |         0 |
  33. | 14 | dudley    | dursley  | 1980-06-23 |             | Cousin d'Harry                        |         1 |
  34. | 18 | ron       | weasley  | 1980-03-01 |             | Best friend of Harry                  |         0 |
  35. | 19 | ginny     | weasley  | 1981-08-11 |             | Sister of Ron and girlfriend of Harry |         0 |
  36. | 20 | fred      | weasley  | 1978-04-01 |             |                                       |         0 |
  37. | 21 | george    | weasley  | 1978-04-01 |             |                                       |         0 |
  38. | 24 | drago     | malefoy  | 1980-06-05 |             |                                       |         0 |
  39. | 28 | dudley    | dursley  | 1980-06-23 |             | Cousin d'Harry                        |         1 |
  40. | 29 | harry     | potter   | 1980-07-31 | london      |                                       |         0 |
  41. | 30 | hermione  | granger  | 1979-09-19 |             | Friend of Harry Potter                |         0 |
  42. | 32 | ron       | weasley  | 1980-03-01 |             | Best friend of Harry                  |         0 |
  43. | 33 | ginny     | weasley  | 1981-08-11 |             | Sister of Ron and girlfriend of Harry |         0 |
  44. | 34 | fred      | weasley  | 1978-04-01 |             |                                       |         0 |
  45. | 35 | george    | weasley  | 1978-04-01 |             |                                       |         0 |
  46. | 38 | drago     | malefoy  | 1980-06-05 |             |                                       |         0 |
  47. | 42 | dudley    | dursley  | 1980-06-23 |             | Cousin d'Harry                        |         1 |
  48. +----+-----------+----------+------------+-------------+---------------------------------------+-----------+
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