UPDATE user SET user_rights="is_sysop"; should do it.
Um, yes, but it will also make every user in the database a sysop. Probably not what he had in mind...
lcrocker@nupedia.com wrote:
UPDATE user SET user_rights="is_sysop"; should do it.
Um, yes, but it will also make every user in the database a sysop. Probably not what he had in mind...
Well, at least you don't leave anybody out that way. :)
Lee is correct, use a WHERE clause. And, I forgot that the "is_" is no longer used on phase III. Oy! Any other misinformation I can give you?
-- brion vibber (brion @ pobox.com)
wikitech-l@lists.wikimedia.org