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

Build the whole recenzje shelf

Combine types and constraints in one complete CREATE TABLE statement.

Task

Write a CREATE TABLE statement that creates the recenzje table with columns: id of type INT with AUTO_INCREMENT and PRIMARY KEY, ksiazka_id of type INT NOT NULL, ocena of type INT, tresc of type TEXT and data_dodania of type DATE.