Kursusindhold
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
Løsning
Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående mulighederTak for dine kommentarer!
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
Løsning
Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående mulighederTak for dine kommentarer!
Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående muligheder