Advertisement
Guest User

Untitled

a guest
Oct 18th, 2019
111
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.15 KB | None | 0 0
  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` LIKE 'potter' ORDER BY `firstname` ASC;
  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)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement