On delete cascade alternate
===

I am trying to create a database for child and parent. Tables looks like.

> **ChildTable**  :  _child-id_(pk) | _parent-id_(fk) | _name_
>
> **ParentTable** : _parent-id_(pk) | _name_
> 
> **_FOREIGN KEY ParentTable(parent-id) REFERENCES  ChildTable(parent-id) ON DELETE CASCADE_**
>


**Problem:**  a parent can have more than one children and parent table is dependent on child table. If a parent is having two children and we delete one children record from _**ChildTable**_ it would delete the parent as well while parent record must exist for another child whose record is still in database.

Is there any other MySQL method/constraint that can fulfill the above requirement.

Thanks in advance.