How to truncate (empty) table qa_words?

Question

Ran into this problem:

TRUNCATE  `qa_words`

MySQL said: Documentation

#1701 - Cannot truncate a table referenced in a foreign key constraint (`mydatabase`.`qa_posttags`, CONSTRAINT `qa_posttags_ibfk_2` FOREIGN KEY (`wordid`) REFERENCES `mydatabase`.`qa_words` (`wordid`))

Answer 1

Sounds cheap, but I just used:

DELETE FROM `qa_words`

Comments

qa_words being  one of the core table which links tags, category names, hence mysql throws an error for foreign key constraints. you can set foreign key constraints to zero and then run truncate. That should do.