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

A reader with a unique e-mail

Make sure every reader's e-mail address is unique.

Task

Write a CREATE TABLE statement that creates the czytelnicy table with columns: id of type INT with AUTO_INCREMENT and PRIMARY KEY, imie of type VARCHAR(50) NOT NULL and email of type VARCHAR(120) with the UNIQUE constraint.