Member Avatar for 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!

  • 2 Contributors
  • 2 Replies
  • 75 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by baig772
Member Avatar for baig772

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

Edited by baig772 because: n/a
Member Avatar for baig772

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.