Login
Вопрос по SQL
2535 просмотров
Перейти к просмотру всей ветки
in Antwort moose 02.06.20 17:32, Zuletzt geändert 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.
Первый пункт как минимум.