Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
7. Updating the circle table – circumference


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.


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)