Error 1451 with "on update cascade" and "on delete cascade"

Asked Jul 17 '21 at 17:20

Active Jul 18 '21 at 09:12

Viewed 260 times

I created a table like this

CREATE TABLE progettoschemas.categories (
  id DOUBLE NOT NULL,
  name VARCHAR(255) NOT NULL,
  fatherid DOUBLE,
  PRIMARY KEY (id),
  FOREIGN KEY (fatherid) REFERENCES progettoschemas.categories(id) ON UPDATE CASCADE ON DELETE CASCADE)

but when I do this query:

UPDATE categories SET id = 33 WHERE id = 1

I get: Error Code: 1451. Cannot delete or update a parent row: a foreign key constraint fails (categories, CONSTRAINT legame_padrefiglio FOREIGN KEY (fatherid) REFERENCES categorie (id))

What am I doing wrong?

This is a representation of my database

edited Jul 18 '21 at 08:47

asked Jul 17 '21 at 17:20

Lorenzo Cutrupi

ca we see all of your datas. – bigtheo Jul 17 '21 at 20:04
Does this answer your question? [mysql error 1451](https://stackoverflow.com/questions/4505624/mysql-error-1451) – bigtheo Jul 17 '21 at 20:06
@bigtheo I don't think so, it looks slightly different. Btw I'm adding my datas to the post – Lorenzo Cutrupi Jul 18 '21 at 08:41
Check the 2nd paragraph here: https://dev.mysql.com/doc/mysql-reslimits-excerpt/8.0/en/ansi-diff-foreign-keys.html – forpas Jul 18 '21 at 09:13
@forpas thank you. So basically I can't do on update cascade for my db? – Lorenzo Cutrupi Jul 18 '21 at 14:53
I'm afraid so... – forpas Jul 18 '21 at 15:06

Error 1451 with "on update cascade" and "on delete cascade"

0 Answers0