Error 1217
Error 1217: can't delete or Update a parent row: a foreign key constrain Fail in mysql.
This is the funny things all tables would be deleted except some of left due to the Foreign key constrain. Wheneve you try to drop database then you got same aforesaid message.
If you disable the Foreign key check or You should be set Foreign_key_Check=0
For instance
Set Foreign_key_check=0;
Drop table myfirsttabletodrop;
Drop table mysecoubdtabletodrop
Set foreign_key_check=1;
I hope you will solve your problem.
Have a nice day.
This is the funny things all tables would be deleted except some of left due to the Foreign key constrain. Wheneve you try to drop database then you got same aforesaid message.
If you disable the Foreign key check or You should be set Foreign_key_Check=0
For instance
Set Foreign_key_check=0;
Drop table myfirsttabletodrop;
Drop table mysecoubdtabletodrop
Set foreign_key_check=1;
I hope you will solve your problem.
Have a nice day.
Casino, Spa, Cabazon, CA Jobs - Mapyro
ReplyDeleteFind the best 화성 출장마사지 casino and spa 진주 출장안마 in Cabazon, CA. 광주 출장마사지 It's located in Cabazon, CA in 동두천 출장마사지 a neighborhood just 울산광역 출장안마 a five minutes' drive from the center.