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.
Task
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
Switch to desktop for real-world practiceContinue from where you are using one of the options belowEverything was clear?
Thanks for your feedback!
SectionΒ 4. ChapterΒ 12
Switch to desktop for real-world practiceContinue from where you are using one of the options below