Contenuti del Corso
Introduction to SQL
Introduction to SQL
Challenge: Correct Book's Data
The library staff discovered an error in the database for the books table. A recently added book has incorrect information, and you need to update it.
Specifically:
The book with book_id = 5 currently has the title 'The Greatest Gatsby'. However, the title was entered incorrectly, and it should be updated to 'The Great Gatsby'.
Additionally, this book's is_available status is incorrect and should be set to FALSE because it has been lent out.
Swipe to start coding
Your task is to write an UPDATE statement to correct this information in the books table.
The syntax of the UPDATE statement is:
sql
Soluzione
Cambia al desktop per esercitarti nel mondo realeContinua da dove ti trovi utilizzando una delle opzioni seguentiGrazie per i tuoi commenti!
Challenge: Correct Book's Data
The library staff discovered an error in the database for the books table. A recently added book has incorrect information, and you need to update it.
Specifically:
The book with book_id = 5 currently has the title 'The Greatest Gatsby'. However, the title was entered incorrectly, and it should be updated to 'The Great Gatsby'.
Additionally, this book's is_available status is incorrect and should be set to FALSE because it has been lent out.
Swipe to start coding
Your task is to write an UPDATE statement to correct this information in the books table.
The syntax of the UPDATE statement is:
sql
Soluzione
Cambia al desktop per esercitarti nel mondo realeContinua da dove ti trovi utilizzando una delle opzioni seguentiGrazie per i tuoi commenti!
Cambia al desktop per esercitarti nel mondo realeContinua da dove ti trovi utilizzando una delle opzioni seguenti