Your first database
You'll open a database and figure out which tables and columns it has, write your first SELECT queries with WHERE, ORDER BY and LIMIT, add and fix a row, and create a table of your own.
- Look inside the databaseeasy
- Your first SELECT: a price listeasy
- WHERE: what's out of stockeasy
- ORDER BY and LIMIT: the three most expensiveeasy
- LIMIT without ORDER BYinterview questioneasy
- INSERT: a new producteasy
- UPDATE: a new price for the kettleeasy
- UPDATE without WHEREinterview questioneasy
- CREATE TABLE: a suppliers tableeasy