It's Autumn! Prices fall like leaves! - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
7. Updating the circle table – circumference
Summary

Instruction

Awesome! We have successfully tested the get_circumference(diameter) function and know that it returns the correct circumference values.

Now, let's use this function and update the circumference value for all records in the circle table.

Exercise

Write an UPDATE statement that updates all records of the circle table and sets circumference to be the result of the function call get_circumference(diameter). Be sure to pass in the correct column to this function.

Stuck? Here's a hint!

Here's the correct answer:

UPDATE circle
SET circumference = get_circumference(diameter)