Learn Relational Databases by Building a Mario Database - Build a Mario Database

Backend Development
1

Tell us what’s happening:
I’m practising with this part, first I cannot connect anymore to the virtual environment: I don’t know whether it’s my pc’s problem or not. Secondly, I write the code in SQL to change the ‘favorite_color’ of Tod by [UPDATE characters SET favorite_color = ‘Blue’ WHEN character_id = 4;], but the console doesn’t run the code correctly.

What to do in this 2 cases?

thank you

Your code so far

Your browser information:

User Agent is: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36

Challenge: Learn Relational Databases by Building a Mario Database - Build a Mario Database

Link to the challenge:

2

Hi there,
you just have a typo in your code.
it’s not
WHEN condition
but
WHERE condition
:smiley:

3

yes it’s just a typing error i did here, the error was about the console, some problem with my terminal apparently.

thank you btw