foreign key Not reflected in Child Table

Honey_Brinda

• September 26, 2016 03:01

Dear All, i'm new to Cpanel with Mysql(Phpmyadmin). Created two table with primary foreign key relation. Primary Table - ProductTable - PID Foreign Table - ProductListTable - PID i did following steps :- 1. changed storage engine type Innodb for both tables 2. both tables PID column added index. 3. Foreign Table - relation view - add ProductTable.PID. with CASCADE (Update,Delete) while i update anything in Primary Table that changes not reflected in Foreign Table. can u please anyone tell the flow of foreign key concept in cpanel.

• 

  cPanelMichael

  • October 06, 2016 15:37

  Hello, You can find MySQL documentation on foreign keys at: MySQL :: MySQL 5.6 Reference Manual :: 13.1.17.3 Using FOREIGN KEY Constraints Could you look over this document and let us know what in-particular isn't working as expected? Also, your access level is listed as "Website Owner". Have you reported the issue to your web hosting provider so they can take a closer look at your database? Thank you.

  0

Please sign in to leave a comment.