What is the best way to store meta tags?
For example, let's take StackOverFlow's question tags. Would you store those separately in their own table with a many-to-many table linking questions and tags? Or is it best to store them as a coma-delimi开发者_JAVA技巧ted list in the row of the question? Now assume the same scenario for a DVDs or games... I'm not sure how to go about this, and some advice would be appreciated.
My database is MySQL
i believe that having a table to resolve the m:m relationship would probably serve you best. you can query on it, display the data without having to break out a comma-delemited field, and you can index the data.
精彩评论