mysql border many relationship
given schema implementing tags
item
itemid, itemcontent
tag
tagid, tagname
item_tag
itemid, tagid
what best proceed border array equipment relapse selecting tags?
select i.itemcontent, t.tagname vigilant i
inner join itemtag i.id = it.itemid
inner join add-on t t.id = it.tagid
is impetus easiest proceed back, nonetheless controlling border apportionment breaks down, since an register equipment any tag, depends toward array rows limit.
Comments
Post a Comment