How to relate 2 fields in different tables

apenster

I have Mysql MyIsam types of tables or something.

table1 has a field cat_id and table2 too.

now if i change the values of cat_id unintendetly, how can i make sure that the field cat_id in table 2 is also changed. I do not want to make scripts everytime that does this, I just want to relate table1.cat_id to table2.cat_id, but how do I do this?

P.S. I am using ensim.

p.s. 2 thanks in advance!

Drakla

MyISAM tables don't have referential integrity on foreign keys, so you will have to write queries that update both values.

apenster

Originally posted by Drakla
MyISAM tables don't have referential integrity on foreign keys, so you will have to write queries that update both values.

i can choose from

myisam
heap
merge
berkeley db
isam

so it basically means that i cannot use relational databases with myisam?

Drakla

No - you can have a relational database with MyISAM, it just doesn't support referential integrity, meaning you have to code knowing it's not going to do cascade updates or deletes.

I haven't used Berkley, but I think that has all the extras in that you're looking for, but isn't as fast as MyISAM on selects.

apenster

thanks, i read that of all the mysql databases in the world 98% are MyISAM/ISAM. I will stick to that type, since i am going to have thousands of records. thanks dude.