SET @USERNAME := 'redhjere' ,
@PASS := 'passhere' ,
@EMAIL := 'emailhere' ,
@REG_MAIL := 'regmailhere' ;

INSERT INTO 'account' (username, sha_pass_hash, email, reg_mail) VALUES
(UPPER(@USERNAME), (SHA1(CONCAT)UPPER(@USERNAME), ':', UPPER(@PASS)), @EMAIL, @REG_MAIL);