DELIMITER //
 CREATE PROCEDURE sp_regUser(
 IN user VARCHAR(100),
 IN name VARCHAR(50),
 IN surname VARCHAR(50),
 IN email VARCHAR(250),
 IN password VARCHAR(250),
 IN telephone VARCHAR(15),
 IN street VARCHAR(120),
 IN postalcode VARCHAR(6),
 IN id INT,
 IN birthdate DATE,
 IN message VARCHAR(320),
 IN photo LONGBLOB,
 IN photoName VARCHAR(50),
 IN role VARCHAR(10)
 )
 BEGIN
INSERT INTO klientet(Perdoruesi,K_Emri,K_Mbiemri,K_Email,Fjalekalimi,K_T_Kontaktues,K_Rruga,K_KodiPostar,ID_Qyteti,K_Datelindja,Mesazh_shtese,Foto,Foto_Emri,Roli)
 VALUES(user, name, surname, email, password, telephone, street, postalcode, id, birthdate, message, photo, photoName, role);
 END//
 DELIMITER ;

CALL sp_regUser('arlind','Arlind','Hajdari','arlind.hajdari@smth.com','perdorimi','0037745231807','Muhaxhiret 13','60000',8,'2016-01-01','miredita',LOAD_FILE('E:/Koala.jpg'),'image.jpg','user')