Default behavior in mysql on delete

Question

If I do this

ALTER TABLE `table`
ADD CONSTRAINT `FK_table` 
FOREIGN KEY (`IDtable`) 
REFERENCES `table2` (`ID`) 
ON UPDATE CASCADE;

What is default behavior for ON DELETE? Is it restrict, cascade, set null?

`NO ACTION` Related; [What is MySQL's default ON DELETE behavior?](http://stackoverflow.com/questions/1027656/what-is-mysqls-default-on-delete-behavior) — Sam Nicholls, Jul 13 '13 at 11:59

juergen d · Accepted Answer · 2013-07-13T15:05:46.707

1

If you don't set an action, the default will be NO ACTION.

edited Jul 13 '13 at 15:05

answered Jul 13 '13 at 11:59

juergen d

3

Which is the same as `RESTRICT`. – apartridge Jul 13 '13 at 11:59
`RESTRICT` and `NO ACTION` are ***not*** the same in the SQL standard, but *are* the same in MySQL. – mtraceur Dec 14 '20 at 21:28

1 Answers1