Challenge: Further Improving the Books Table
As one more improvement to the books_table
table, you can specify some default values to make the data entry process more efficient.
Swipe to start coding
Your task is to write a query for creating a new books_table
table for the library that will include default values for certain columns. This ensures that if no value is provided during insertion, the system will use a predefined default value.
Set default values for the following columns:
genre
β'Unknown'
;pages
β0
;language
β'English'
;is_available
βTRUE
.
Solution
Thanks for your feedback!
single
Ask AI
Ask AI
Ask anything or try one of the suggested questions to begin our chat
Awesome!
Completion rate improved to 1.72
Challenge: Further Improving the Books Table
Swipe to show menu
As one more improvement to the books_table
table, you can specify some default values to make the data entry process more efficient.
Swipe to start coding
Your task is to write a query for creating a new books_table
table for the library that will include default values for certain columns. This ensures that if no value is provided during insertion, the system will use a predefined default value.
Set default values for the following columns:
genre
β'Unknown'
;pages
β0
;language
β'English'
;is_available
βTRUE
.
Solution
Thanks for your feedback!
Awesome!
Completion rate improved to 1.72single