On Thu, Feb 27, 2003 at 09:27:41AM -0500, Brent Baisley wrote: > Maybe you should rethink your whole database structure. In your > simplified example, you really only have two pieces of data, the text > and a qualifier (a, b, c, d, e, ...). So instead of separating your > "text" into different columns, keep all your text in one column and add > another column that acts as the qualifier. > You could even merge your tables since they would both end up having the > exact same structure. You can then do self joins instead of your cross > table joins. > Finally, this structure allows you to create unlimited qualifiers > without having to modified the structure of your tables or indexes. > Your idea is very interesting. > > Of course, this is all based on your simplified example.
Now I must think over if I am able to implement it in my more complex situation :) Thanks. -- Grzegorz mysql,sql,query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
