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.