MySQL - MyISAM multi-table delete (similar to ON CASCADE DELETE)?

Maybee not the best solution, but it works: DELETE FROM form_options_info, form_options, forms USING forms INNER JOIN form_options INNER JOIN form_options_info WHERE (form_options_info. Form_options_id = form_options. Id AND form_options.

Form_id = forms. Id OR form_options. Form_id = forms.Id) AND forms.

Id = 2 or just change the tables to InnoDB ;-).

Maybee not the best solution, but it works: DELETE FROM form_options_info, form_options, forms USING forms INNER JOIN form_options INNER JOIN form_options_info WHERE (form_options_info. Form_options_id = form_options. Id AND form_options.

Form_id = forms. Id OR form_options. Form_id = forms.Id) AND forms.

Id = 2; ...or just change the tables to InnoDB ;-)...

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions