create tmp table - how to use?

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

Jaro

>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
);

"Gordon Burditt" <gordonb.a1ipg@burditt.org> schreef in bericht
news:12g2lo9f5trci75@corp.supernews.com...
> >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
> );
>


is spamming a TEMPORARY issue?

;-)

>> >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
>> );
>>
>
>
>is spamming a TEMPORARY issue?

The current consolidated block list (which is generated from a number
of tables, then stuck in a dbm file used by sendmail) is a temporary
thing.

Gordon L. Burditt