Hi,
I like to manipulate the user options of some users belonging to a certain user group via database access or maybe cloning the setting of a standard user. What I found so far is a description on how to alter the setting of the user options -- update user set user_options=replace(.. -- but I could not find a description on how to add certain options.
Any help available?
Kind regards Albert Cremer
P. S.
Why is the mySql command line tool able to show the user options in plain text whereas other tools (e. g. SQLDeveloper) are not?
On 16/07/07, a. cremer albert.cremer@online.de wrote:
Why is the mySql command line tool able to show the user options in plain text whereas other tools (e. g. SQLDeveloper) are not?
user.user_options is a BLOB, which a lot of tools won't show without setting some option.
Rob Church
When I got it right it is a string separated by \n.
Is there any advice how to append something to that string via mySQL?
Regards
Albert Cremer
"Rob Church" robchur@gmail.com schrieb im Newsbeitrag news:e92136380707161420j7af992cdq933eb8814a4e5696@mail.gmail.com...
On 16/07/07, a. cremer albert.cremer@online.de wrote:
Why is the mySql command line tool able to show the user options in plain text whereas other tools (e. g. SQLDeveloper) are not?
user.user_options is a BLOB, which a lot of tools won't show without setting some option.
Rob Church
mediawiki-l@lists.wikimedia.org