Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

How to INSERT, UPDATE, and DELETE Data in SQL

Quiz
2. The animal table

Instruction

Let's analyze the first table, animal, which contains data about the animals in the zoo.

Exercise

Select all the information from the animal table. Each animal has the following info:

  • id – a number that identifies each animal in the database.
  • species – the species of the animal.
  • name – the name of that animal.
  • city – the city where that animal came from.
  • age – the age of the animal.
  • arrived_date – when that animal arrived at the zoo. The default value for this column is current date.
  • picture – a link to the photo of the animal; if there is no photo, this field will store the string 'img/no-photo.jpg'.