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

Primary key with auto-numbering

Combine the type with constraints to create a correct primary key.

Task

Write a CREATE TABLE statement that creates the kategorie table with columns: id of type INT with the AUTO_INCREMENT and PRIMARY KEY constraints, and nazwa of type VARCHAR(100) with the NOT NULL constraint.