Jeremy Cole пишет:
> Hi Vladimir,
>
>>> Another note, () are also reserved in hostnames, so you could use
>>> "(role)" which would be perfectly clear I think.
>>
>> Sure, but parentheses must also be escaped in most of scripting
>> languages.
>
> So must many other characters used in SQL: quotes, at-sign, etc. -- but
> why does it matter? The user should basically almost never be using
> that reserved value for anything. It would exist as a #define in the
> code, and get stored in the column, but the user would only use the
> role-specific commands to deal with it, thus never seeing that reserved
> value.
>
But didn't you ever do anything like
delete from `mysql`.`users` where `host` like '%.bigbucks.com'?
You would also like to black/greylist some very special hosts
there with a script using $host as a loop variable.
Btw, this is another reason against '%' sign :)
Regards,
Vladimir
