Re: [Exim] mysql lookups / !SELECT / affected_rows

Kezdőlap
Üzenet törlése
Válasz az üzenetre
Szerző: Alexander Sabourenkov
Dátum:  
Címzett: exim-users
CC: Nico Erfurth
Tárgy: Re: [Exim] mysql lookups / !SELECT / affected_rows
Hello.

Nico Erfurth wrote:
>
>
> What's !SELECT for?


Not SELECT [-like].

I.e. UPDATE, DELETE, INSERT, GRANT/REVOKE (not that this is likely to be used in lookups :-) ).
They do not return result sets.

Problem was, I needed to insert rows into a table to implement some hairy rate-limiting scheme.
And although query was succeeding, and rows were inserted, the lookup returned 'defer'.


--

./lxnt