UPDATE - Modifying Records1 / 10
UPDATE lets you change one or more value in one or more row of the table. Take a look at the animals table below and try:
UPDATE animals SET lifespan_years = 15 WHERE animal_id = 1;| animal_id | animal_name | species | habitat | lifespan_years |
|---|---|---|---|---|
| 1 | Leo | Lion | Savanna | 14 |
| 2 | Ellie | Elephant | Savanna | 60 |
| 3 | Stripes | Tiger | Jungle | 20 |
| 4 | Manny | Manatee | Ocean | 50 |
| 5 | Polly | Parrot | Rainforest | 40 |
| 6 | Sam | Salmon | River | 7 |
| 7 | Oscar | Owl | Forest | 15 |
Ctrl+Enter to submit
UPDATE - Modifying Records - Free SQL Practice Online
Practise UPDATE - Modifying Records with 10 free, interactive SQL exercises. You type real queries into your browser and get instant feedback on every answer - no database setup, no install, and no signup. It is a fast, hands-on way to learn SQL online and build query skills you can use at work.