Coding task · SQL and MySQL course · Module 4: Creating tables (DDL)

A column with a default value

Set a newly added book to be available by default.

Task

Write a CREATE TABLE statement that creates the egzemplarze table with columns: id of type INT with AUTO_INCREMENT and PRIMARY KEY, and dostepna of type BOOLEAN with a default value of TRUE.