long lists

[andreon]

Hi,

I want to create a new list "All" so that every member can e-mail all the other members easily.
Once created a list named "All'' one needs to assign members. I cannot (of course)
assign all >550 members clicking one by one. How can I assign all members in the list "All"?

Regards, Stefano

[XimeX]

The easiest way for a one time job would be to write an SQL query that adds all users to the role and execute this directly in the database

[andreon]

I was thinking the same but

in which columns of which table is stored the quantity to be updated?

I know how to update something in the database with a value, but I need to know
"value" and "something". I browsed all tables, but nothing comes to my mind.

Thanks, Stefano

[XimeX]

the query isn't so easy. I think fasse could help you better here. But maybe this helps