3 ms·
Why have an m2m table? Just have a table with two columns: post_id (or whatever is being tagged) and tag (varchar). If you want to present a list of possible ta
by sopooneo 14y ago
Why have an m2m table? Just have a table with two columns: post_id (or whatever is being tagged) and tag (varchar). If you want to present a list of possible tags just query for uniques. I may be missing something, so please correct me if there is a better way or I am misunderstanding your point.
- est 14y agothere are three design patterns for tags in a table based db http://forge.mysql.com/wiki/TagSchema http://forge.mysql.com/wiki/TagSchema
- ericcoleman 14y agoLink is dead... Just redirects to dev.mysql.com Cache link, since I can't find it on dev.mysql.com: http://webcache.googleusercontent.com/search?q=cache:II_A7LFmN-UJ:forge.mysql.com/wiki/TagSchema+http://forge.mysql.com/wiki/TagSchema&cd=1&hl=en&ct=clnk&gl=us http://webcache.googleusercontent.com/search?q=cache:II_A7LF...