Author: Alexander Sabourenkov Date: To: exim-users CC: Nico Erfurth Subject: 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'.
