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