I have Post HABTM Tags (tables: posts, tags, posts_tags).
When I delete Post also deleting relations from post_tags table - it's okey, but in table tags there are still not used tags.
How resolved remove not uset tags?
Asked
Active
Viewed 78 times
0
Brian Tompsett - 汤莱恩
- 5,753
- 72
- 57
- 129
kicaj
- 2,881
- 5
- 42
- 68
-
Did you set `dependant` in your model relationships? – David Yell Aug 20 '13 at 09:48
-
There is no option `dependent` for HABTM – kicaj Aug 20 '13 at 10:23
-
@kicaj Please always mention the exact CakePHP Version you are using! – ndm Aug 20 '13 at 11:22
-
I would consider changing this to `hasMany Through` http://book.cakephp.org/2.0/en/models/associations-linking-models-together.html#hasmany-through-the-join-model – David Yell Aug 20 '13 at 11:36
-
@ndm: I use the last 2.3.9 – kicaj Aug 20 '13 at 12:10
1 Answers
0
Okey, I found the simplest way: https://stackoverflow.com/a/1451323/182823:
DELETE FROM tags WHERE not exists (SELECT * FROM tags_places WHERE tags_places.tag_id = tags.id)
