Вход на сайт
Вопрос по SQL
2535 просмотров
Перейти к просмотру всей ветки
в ответ moose 02.06.20 17:32, Последний раз изменено 02.06.20 17:49 (NightWatch)
https://mariadb.com/kb/en/foreign-keys/
1. Note: MariaDB accepts the REFERENCES clause in ALTER
TABLE and CREATE TABLE statements, but that syntax does nothing. MariaDB
simply parses it without returning any error or warning, for
compatibility with other DBMS's. However, only the syntax described
below creates foreign keys.
2. Currently, foreign keys are only supported by InnoDB.
3. Foreign key constraints can be disabled by setting the foreign_key_checks server system variable to 0.
Первый пункт как минимум.