title: Delete a MySQL record involved in a foreign key without deleting children
body: <p>i am trying to delete a row of information from a parent table without deleting anything from the child table. the foreign key constraint is set to delete no action. because i want to delete the information while leaving the corresponding information in the child table intact. i ant to be able to do this without changing it to delete cascade.......can anybody help me........p.s my database is literally a table consisting of parents and the child table is also literally children....HELP. i have tried doing this but i keep getting the error message. Foreign key constraint prevents update or delete.</p>