Coding task · SQL and MySQL course · Module 5: Modifying data (DML)

Change a reader's city

Use UPDATE with SET and WHERE to change one reader's data. Remember the WHERE!

Task

Write a command that in the czytelnicy table sets miasto to 'Aleksandria' for the reader with id = 7. Be sure to use the WHERE clause.