I have a value that I want to do delete everything from a table that contains this value in a field. Also, each one of those that I delete has an ID that is a foreign key value in another table. I ...

CREATE TABLE folders ( id INT NOT NULL DEFAULT 0, name VARCHAR(255), parentid INT, PRIMARY KEY (id), FOREIGN KEY (parentid) REFERENCES folders(id) ON DELETE CASCADE ) ENGINE=InnoDB; More options ...