Skip to content

Instantly share code, notes, and snippets.

@juliaheller

juliaheller/02 - Retrieving information with SELECT

Created March 10, 2020 11:52
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save juliaheller/da04cd37123748f6ea552e4a11a9e0ab to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save juliaheller/da04cd37123748f6ea552e4a11a9e0ab to your computer and use it in GitHub Desktop.
Download ZIP
Raw
02 - Retrieving information with SELECT
mysql> select * from wizard where birthday between '1975-01-01' and '1985-01-01';
+----+-----------+----------+------------+-------------+---------------------------------------+-----------+
| id | firstname | lastname | birthday | birth_place | biography | is_muggle |
+----+-----------+----------+------------+-------------+---------------------------------------+-----------+
| 1 | harry | potter | 1980-07-31 | london | | 0 |
| 2 | hermione | granger | 1979-09-19 | | Friend of Harry Potter | 0 |
| 4 | ron | weasley | 1980-03-01 | | Best friend of Harry | 0 |
| 5 | ginny | weasley | 1981-08-11 | | Sister of Ron and girlfriend of Harry | 0 |
| 6 | fred | weasley | 1978-04-01 | | | 0 |
| 7 | george | weasley | 1978-04-01 | | | 0 |
| 10 | drago | malefoy | 1980-06-05 | | | 0 |
| 14 | dudley | dursley | 1980-06-23 | | Cousin d'Harry | 1 |
+----+-----------+----------+------------+-------------+---------------------------------------+-----------+
8 rows in set (0,01 sec)
mysql> select firstname, lastname from wizard where firstname like 'H%';
+-----------+----------+
| firstname | lastname |
+-----------+----------+
| harry | potter |
| hermione | granger |
+-----------+----------+
2 rows in set (0,01 sec)
mysql> select firstname, lastname from wizard where lastname ='Potter' order by firstname;
+-----------+----------+
| firstname | lastname |
+-----------+----------+
| harry | potter |
| lily | potter |
+-----------+----------+
2 rows in set (0,01 sec)
mysql> select firstname, lastname, birthday from wizard order by birthday desc limit 1;
+-----------+----------+------------+
| firstname | lastname | birthday |
+-----------+----------+------------+
| ginny | weasley | 1981-08-11 |
+-----------+----------+------------+
1 row in set (0,00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment