FAQ: Manipulation - Update


#1

This community-built FAQ covers the “Update” exercise from the lesson “Manipulation”.

Paths and Courses
This exercise can be found in the following Codecademy content:

Web Development
Data Science

Learn SQL

FAQs on the exercise Update

Join the Discussion. Help a fellow learner on their journey.

Ask or answer a question about this exercise by clicking reply (reply) below!

Agree with a comment or answer? Like (like) to up-vote the contribution!

Need broader help or resources? Head here.

Looking for motivation to keep learning? Join our wider discussions.

Learn more about how to use this guide.

Found a bug? Report it!

Have a question about your account or billing? Reach out to our customer support team!

None of the above? Find out where to ask other questions here!


#2

are commands lines interchangeable? ex:
instead of :
SET twitter_handle = ‘@taylorswift13
WHERE id = 4;

could we use :
WHERE id = 4
SET twitter_handle = ‘@taylorswift13’;


#3

What if there are two rows with the same value for id?


#4

There is a bug in exercise 8/11:

New twitter_handle column from exercise 7 is automatically removed when you try to run exercise 8


#5

Refreshing the URL and pressing on the solution button right away works