Geek asks and answers

Foreign key on an alternate meisam table?

I am working on a website that needs to use foreign keys, but I searched for it and the shared host does not support innoDB. I use the MyISAM engine. Is there an alternative to using foreign keys?

What I need:

table_image {
image_id (PK) 
}

table_ratings {
rating_id(PK) 
image_id(FK) 
}

Thanks in advance.

+5
source share
1 answer

I struggled with hell before, fortunately, switched to innoDb.

I implemented all insertions / remove cascading logic using a bunch of online / batch scripts ...

But this may actually be good, because in some special situation you can disable cascading operations, which are not always bad ideas regarding performance.

Rgds.

+2
source

More articles:


All Articles