drop database mordor;
create database mordor;
use mordor;

create table studenci(
	id_studenta INT auto_increment primary key,
    imie varchar(20),
    nazwisko varchar(20),
    uczelnia varchar(40),
    Miejsce_zam varchar(20),
    rok_studiow varchar(20),
    dochod_na_osobe int
    );

    load data local infile "/Users/4TI2_gr2/Desktop/studenci.txt" into table studenci fields terminated by','  lines terminated by '\r\n';