I try to do the following: cur.execute("TRUNCATE TABLE words") (using a connection con and a cursor cur = con.cursor that worked elsewhere).
The strange thing is, it worked with other tables. I tried to do cur.execute("SET_FOREIGN_KEY_CHECKS = 1") first, but that doesn't work either. What could be going wrong?