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

Pàgina inicial
Delete this message
Reply to this message
Autor: Alexander Sabourenkov
Data:  
A: exim-users
CC: Nico Erfurth
Assumpte: 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