Gleb Paharenko wrote:
Hello.
I think that SET FOREIGN_KEY_CHECKS = 0; could help you.
Thanks, I didn't think about it. I've I dumped the DB and recreate it
instead.
Philippe Poelvoorde <[EMAIL PROTECTED]> wrote:
Hello,
I've got an innodb that I try to drop:
drop table markets;
ERROR 1217 (23000)
Hello.
I think that SET FOREIGN_KEY_CHECKS = 0; could help you.
Philippe Poelvoorde <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I've got an innodb that I try to drop:
>
> drop table markets;
> ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key
> constraint fails
Hello,
I've got an innodb that I try to drop:
drop table markets;
ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key
constraint fails
Ok, I check with show innodb status :
050401 11:13:41 Cannot drop table `dabase/markets`
because it is referenced by `dabase/last`
then :
dro