⚝
One Hat Cyber Team
⚝
Your IP:
216.73.216.124
Server IP:
50.28.103.30
Server:
Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
Server Software:
nginx/1.28.0
PHP Version:
8.3.12
Buat File
|
Buat Folder
Eksekusi
Dir :
~
/
www
/
server
/
mysql
/
mysql-test
/
suite
/
ndb
/
r
/
View File Name :
ndb_fk_setdefault.result
create table counties ( county varchar(30) not null primary key, country varchar(30) ) engine=ndb; insert into counties values ('Berkshire','England'),('Shropshire','England'), ('Oxfordshire','England'),('Buckinghamshire','England'),('Somewhere','Earth'); create table towns ( town varchar(30) not null primary key, county varchar(30) default "Somewhere", index county_county_index (county), constraint county_town foreign key (county) references counties(county) on delete set default on update restrict ) engine=ndb; insert into towns values ('Maidenhead','Berkshire'),('Reading','Berkshire'), ('Shrewsbury','Shropshire'),('Oxford','Oxfordshire'); delete from counties where county='Shropshire'; ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails (Unknown error code) show warnings; Level Code Message Warning 1296 Got error 256 'Foreign key constraint violated: Referenced row exists' from NDB Error 1451 Cannot delete or update a parent row: a foreign key constraint fails (Unknown error code) drop table towns, counties;