Как удалить теги?

Как удалить теги из базы, все и сразу?

Trustmaster	#29256 2011-04-01 11:09
Administrators Thanked: 265 kez	Пробуем DELETE FROM sed_tags WHERE (SELECT COUNT() FROM sed_tag_references WHERE sed_tags.tag = sed_tag_references.tag) <= 2; DELETE FROM sed_tag_references WHERE (SELECT COUNT() FROM sed_tags WHERE sed_tag_references.tag = sed_tags.tag) = 0; May the Source be with you!
Bu gönderi Trustmaster tarafından düzenlendi (2011-04-02 08:22, 14 yıllar önce)

Trustmaster

#29256 2011-04-01 11:09

Пробуем

DELETE FROM sed_tags WHERE (SELECT COUNT(*) FROM sed_tag_references WHERE sed_tags.tag = sed_tag_references.tag) <= 2;
DELETE FROM sed_tag_references WHERE (SELECT COUNT(*) FROM sed_tags WHERE sed_tag_references.tag = sed_tags.tag) = 0;

May the Source be with you!

Bu gönderi Trustmaster tarafından düzenlendi (2011-04-02 08:22, 14 yıllar önce)