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 Quote 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. Quote 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 Quote 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" Quote 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... Quote Link to comment https://forums.phpfreaks.com/topic/143890-query-help-please/#findComment-755141 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.