I have two tables like this:

CREATE TABLE parent
(
par_id INT NOT NULL,
PRIMARY KEY (par_id)
) ENGINE = INNODB;

CREATE TABLE child
(
par_id INT NOT NULL,
child_id INT NOT NULL,
PRIMARY KEY (par_id, child_id),
FOREIGN KEY (par_id) REFERENCES parent (par_id)
ON DELETE CASCADE
ON UPDATE CASCADE
) ENGINE = INNODB;

When I delete anything from the parent table, it deletes everything related to the parent table. This is OK.

But when I delete anything from the child table, it does delete it.
It was not supposed to because the foreing key.

What do I need to do to only be able to delete from the parent table?
I would like to have a message saying that record can not delete because thats a child table.

Thanks
Roger.

Why shouldn't it be supposed to delete the data ? You can delete lines in child when you have a foreign key constraint. Example : you have a clothing store, with a shirts section : you can stop selling one shirt model, this does not delete the entire section : shirts still exist.
What is forbidden is to delete only par_id, for it references the parent, and should not be null.
I do not think there is a "normal" way to forbid deletion from child table.