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.