MyISAM to InnoDB

[anthonyjpv]

Hi!

Im changing my database engine from MyISAM to InnoDB

its because I learned online that if I were to use FK's that its more likely that I have to use InnoDB

my question is:

if I have a one-to-many relationship tables:

ie. one PK in table 1 can have: many instances of records as FK in table 2 ref in table 1

which should have the cascade on update and delete?

table 1 or table 2

another thing

i know how to alter a table using a console

but do you happen to know if theres a tool in phpmyadmin on how to do it using a GUI?

Thanks!

[baig772]

options are available in phpmyadmin for altering the table i.e. look for operations tab

[baig772]

on update, it depends which table information you are updating, while deleting, both table should have cascade