Re: Err NO. 152 need help

2005-06-30 Thread Gleb Paharenko
Hello. perror 152 MySQL error code 152: Cannot delete a parent row Something prevents your query from deleting a parent row. In my opinion, it could be some lock from another transaction or query. root <[EMAIL PROTECTED]> wrote: > > Hi List , > > what does error no 152 mean , cou

Err NO. 152 need help

2005-06-30 Thread root
Hi List , what does error no 152 mean , could not find anything useful from the manual , was trying to drop a foreign key from an innodb table which has its corresponding P Key in another table. Table T_Dropdown (Foreign Key ) references Table T_Questionnaire ( T_QID ) > mysql >alter table T_Dr