>One of the user privileges is 'create_tmp_table'. Is there any build-in
>function to create temporary table?

How about:

CREATE TEMPORARY TABLE foo (
spammer_id int not null primary key,
spammer_ip varchar(15) not null
);