- Beranda
- Komunitas
- Tech
- Programmer Forum
[SQL] Yang punya problem SQL kumpul disini gan... (no urgent please)
TS
hidayat365
[SQL] Yang punya problem SQL kumpul disini gan... (no urgent please)
Yang mau belajr SQL sama2 sharing di sini ya...
Quote:
Quote:
Quote:
Quote:
Spoiler for "Trit ane yang lain":
Diubah oleh hidayat365 28-03-2014 07:35
tien212700 dan nona212 memberi reputasi
2
359.1K
5K
Guest
Tulis komentar menarik atau mention replykgpt untuk ngobrol seru
Tampilkan semua post
Luminus
#4906
Quote:
sesuai sama url https://dev.mysql.com/doc/refman/5.7...mitations.html
Code:
Foreign keys not supported for partitioned InnoDB tables. Partitioned tables using the InnoDB storage engine do not support foreign keys. More specifically, this means that the following two statements are true:
No definition of an InnoDB table employing user-defined partitioning may contain foreign key references; no InnoDB table whose definition contains foreign key references may be partitioned.
No InnoDB table definition may contain a foreign key reference to a user-partitioned table; no InnoDB table with user-defined partitioning may contain columns referenced by foreign keys.
ya uda pake cara ane aja yang ngga pake "foreign key" secara explisit, cuma repot klo pas mo apus aja jadi ga bisa cascade
toh foreign key cuma membantu integritas data aja biar ngga salah masukin data
0
Tutup