Microsoft Windows [Version 6.3.9600]
(c) 2013 Microsoft Corporation. Wszelkie prawa zastrzeżone.

C:\Users\technikum>cd..

C:\Users>cd..

C:\>cd xampp

C:\xampp>cd mysql

C:\xampp\mysql>cd bin

C:\xampp\mysql\bin>mysql -u root -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 117
Server version: 10.4.6-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> create database baza2d2 default character set utf8 collate utf8_polish _ci;
ERROR 1273 (HY000): Unknown collation: 'utf8_polish'
MariaDB [(none)]> create database baza2d2 default character set utf8 collate utf8_polish _ci;
ERROR 1273 (HY000): Unknown collation: 'utf8_polish'
MariaDB [(none)]> create database baza2d2 default character set utf8 collate utf8_polish _ci;
ERROR 1273 (HY000): Unknown collation: 'utf8_polish'
MariaDB [(none)]> create database baza2d2 default character set utf8 collate utf8_polish_ci;
Query OK, 1 row affected (0.012 sec)

MariaDB [(none)]> use baza2d2
Database changed
MariaDB [baza2d2]> create table
    -> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
MariaDB [baza2d2]> create table(auto_increment, PRIMARY KEY(id));
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(auto_increment, PRIMARY KEY(id))' at line 1
MariaDB [baza2d2]> create table handlowcy (auto_increment, PRIMARY KEY(id));
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' PRIMARY KEY(id))' at line 1
MariaDB [baza2d2]> create table handlowcy;
ERROR 1113 (42000): A table must have at least 1 column
MariaDB [baza2d2]> create table handlowcy(
    -> id handlowcy auto_increment
    -> nazwisko
    -> imie
    -> email
    -> login
    -> show table
    -> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'handlowcy auto_increment
nazwisko
imie
email
login
show table' at line 2
MariaDB [baza2d2]> create table handlowcy(
    -> id handlowcy (VARCHAR 100)
    -> nazwikso (VARCHAR 100)
    -> imie (VARCHAR 100)
    -> email (VARCHAR 100)
    -> login(VARCHAR 100)
    -> auto_increment
    -> PRIMARY KEY (id));
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'handlowcy (VARCHAR 100)
nazwikso (VARCHAR 100)
imie (VARCHAR 100)
email (VARCHAR' at line 2
MariaDB [baza2d2]> create table handlowcy(
    -> idhandlowca int NOT NULL AUTO_INCREMENT,
    -> nazwikso varchar(255) NOT NULL,
    -> imie varchar(255),
    -> email varchr(255),
    -> login varchar(255),
    -> PRIMAY KEY(idhandlowca)
    -> );
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'varchr(255),
login varchar(255),
PRIMAY KEY(idhandlowca)
)' at line 5
MariaDB [baza2d2]> create table handlowcy (
    -> idhandlowca int NOT NULL AUTO_INCREMENT,
    -> nazwikso varchar(255) NOT NULL,
    -> imie varchar(255),
    -> email varchr(255),
    -> login varchar(255),
    -> PRIMAY KEY(idhandlowca)
    -> );
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'varchr(255),
login varchar(255),
PRIMAY KEY(idhandlowca)
)' at line 5
MariaDB [baza2d2]> CREATE TABLE Handlowcy (
    -> idhandlowca int NOT NULL AUTO_INCREMENT,
    -> nazwisko varchar(255) NOT NULL,
    -> imie varchar(255),
    -> email varchar(255),
    -> login varchar(255),
    -> PRIMARY KEY (idhandlowca)
    -> );
Query OK, 0 rows affected (0.222 sec)

MariaDB [baza2d2]> create table Samochody(
    -> id samochodu int NOT NULL AUTO_INCREMENT,
    -> rocznik INT
    -> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'samochodu int NOT NULL AUTO_INCREMENT,
rocznik INT' at line 2
MariaDB [baza2d2]> create table Samochody (
    -> idsamochodu int NOT NULL AUTO_INCREMENT,
    -> rocznik INT,
    -> wartosc INT,
    -> tablica varchar(255),
    -> przebieg INT,
    -> silinik varchar(255),
    -> idmodelu varchar(255),
    -> datawpisu INT,
    -> autorwpisu varchar(255),
    -> PRIMARY KEY(idsamochodu)
    -> );
Query OK, 0 rows affected (0.288 sec)

MariaDB [baza2d2]> create table Modele (
    -> idmodelu int NOT NULL AUTO_INCREMENT