memilan Posted February 5, 2009 Share Posted February 5, 2009 how can i delete the child table data viewing the Key not present in parent table Link to comment https://forums.phpfreaks.com/topic/143890-query-help-please/ Share on other sites More sharing options...
killah Posted February 5, 2009 Share Posted February 5, 2009 Your question is unclear to me. Explain it a little bit more please. Link to comment https://forums.phpfreaks.com/topic/143890-query-help-please/#findComment-755019 Share on other sites More sharing options...
peddel Posted February 5, 2009 Share Posted February 5, 2009 I guess u want to have the child data deleted when u delete parent data. I know how to do this trough phpMyAdmin by using a foreign key relationship with a cascade delete. Just google on "MySQL CASCADE DELETE" and you will find answers, if it is this u seek Link to comment https://forums.phpfreaks.com/topic/143890-query-help-please/#findComment-755100 Share on other sites More sharing options...
memilan Posted February 5, 2009 Author Share Posted February 5, 2009 I have delete the parent data and i havenot defined foreign key relationship so i have to delete the data from child table Viewing the specific Key which not Present in parent table and the Platform is "FireBird" Link to comment https://forums.phpfreaks.com/topic/143890-query-help-please/#findComment-755130 Share on other sites More sharing options...
aschk Posted February 5, 2009 Share Posted February 5, 2009 If this is the firebird db then you have posted the question in the wrong forum... Link to comment https://forums.phpfreaks.com/topic/143890-query-help-please/#findComment-755141 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.