From MySQL Documentation: https://dev.mysql.com/doc/refman/8.0/en/create-table-foreign-keys.html
Some database systems have deferred
checks, andNO ACTIONis a deferred
check. In MySQL, foreign key
constraints are checked immediately,
soNO ACTIONis the same asRESTRICT.