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

A czytelnicy table with a primary key

Create a shelf for readers in which id is an auto-numbered primary key.

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) and nazwisko of type VARCHAR(50).