mysql 在做某個表的外鍵關聯時,提示如下錯誤
後查,該表的存儲引擎為 myisam
在 mysql 的官方文檔中提到,myisam 是 不支援外鍵的,“foreign key support no”。
storage limits
256tb
transactions
no
locking granularity
table
mvcc
geospatial data type support
yes
geospatial indexing support
b-tree indexes
t-tree indexes
hash indexes
full-text search indexes
clustered indexes
data caches
index caches
compressed data
cluster database support
foreign key support
query cache support
update statistics for data dictionary