|
Joining into rows.
I would love to be able to do that, but so far, in all of my questing, nothing of the sort has ever turned up in any database server I have found.
I once tried to hack around it by using a join and joining the same table 8 times or so, naming the tables and columns different things every time. I know that some MySQL developer has my face on a dartboard for that. I quickly learned my lesson (it was cool, until it involved anything over a trivial amount of data, then it all exploded.) and reverted it to a single join, and from that single join, I looped through it in PHP and output a hash of data that my Mom could be proud of.
Sometimes, SQL won't do what you want it to, good thing we have programming languages to fall back on.
On an aside, do you think you are over-engineering this login system? Is a comma-delimited list of permissions somehow totally out of order here? Are you going to need to be able to search by permission for who has it, or are you going to just want to search for if a person has a particular permission. Although it is awful for data normalcy, and the SQL gods will strike me down for saying this, sometimes, it is far far more efficent to just throw a little delimeted list in someplace instead of going through convultions in an attempt to make everything it's own little column and row.
|