Foreign key on myisam table alternative?
mysql, sql
Solution
I struggled the hell before I fortunately switched to innoDb myself.
I had implemented all the inserts/delete cascade logic with a bunch of online/batch scripts...
But it might be ok actually, because in some very special situation you can disconnect cascade operations which is not always a bad idea reguarding to performances.
rgds.
Problem
I am working on a website that need to use foreign keys, but I have searched all around and shared host doesn't support innoDB. I am using MyISAM engine. Is there an alternative for using foreign keys? What I need: ``` table_image { image_id (PK) } table_ratings { rating_id(PK) image_id(FK) } ``` Thanks in advance.