On Fri, 2 Jan 2004, Caroline Jen wrote:
> In case that a user has multiple roles; for example,
> John Dole is both author and editor,
> 1. I should have two rows for John Dole?
> John Dole author
> John Dole editor
> or. I should have only one row and use comma ',' to
> separate the roles?
> John Dole author, editor
> 2. How do I create the table for the second case (see
> create table user_roles (
> user_name varchar(15) not null,
> role_name varchar(15) not null, varchar(15) null
If the roles will not be very dynamic and could be hardcoded you might be
able to use the SET datatype which is described here:
If you will add/update/change/delete roles often, then you should go for
one of the other methods suggested instead, but if the roles are static,
this might work better for you.