Advertisement
Guest User

Untitled

a guest
Oct 15th, 2019
116
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.11 KB | None | 0 0
  1. mysql> 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';
  26. +-----------+----------+
  27. | firstname | lastname |
  28. +-----------+----------+
  29. | harry | potter |
  30. | lily | potter |
  31. +-----------+----------+
  32. 2 rows in set (0.00 sec)
  33.  
  34.  
  35. mysql> SELECT firstname,lastname, birthday FROM wizard ORDER BY birthday ASC LIMIT 1;
  36. +-----------+------------+------------+
  37. | firstname | lastname | birthday |
  38. +-----------+------------+------------+
  39. | albus | dumbledore | 1881-07-01 |
  40. +-----------+------------+------------+
  41. 1 row in set (0.01 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement