How to INSERT, UPDATE, and DELETE Data in SQL

What you get?

Fully interactive online courses. Just you, SQL, Python, R and the web browser.

Instant access to lessons. You decide when and how long you want to learn.

Hundreds of SQL, Python, R exercises to master Your skills.

Course completion certificate to show the world that you really can!

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

4/9 Exercise 1

1. Introduction

2. The animal table

3. The adoptive_person table

Now that we know the data, let's get started!

Data about all the zoo's animals is stored in the animal table. Recall that this table contains these columns:

id
name
species
city
age
arrived_date
picture (default value of 'img/no-photo.jpg')

Insert data into the animal table for two new mammals:

id	species	name	age	arrived_date
6	bear	Max	2	today
7	tiger	Smokey	1	today

At this time, we don't know any more about these animals.

Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings.You can modify your browser settings on your own. For more information see our Privacy Policy.

Instruction

Exercise

Need assistance?

login:
password:
Remember me on this computer

Recipient's Name:
Recipient's Email:
Your Message (Optional):

Create a free accountand start learning now!

What you get?

Sign upand join a company account!

Log in

Your registration has been successfully finished

Wrap course as a gift

Instruction

Exercise

Need assistance?