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!

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

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.