SHARE
TWEET

Untitled

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