Thanks for the reply azzazzello.
I realise I can do that, but I was worried that it would be very inefficient once there are thousands of users in the table.
However, I found out that I can set 'username' to be indexed, and therefore it won't be too inefficent.
I'll get to work on it...
I'm a newbie to databases - well, large ones anyway.
I'm trying to design a database which stores 'bookmarks' for users in a hierchachical fashion. I've figured out how to do that for one person (adjacency list, in one table). So for multiple users, I have one table to store user details -...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.