The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

foreign key Not reflected in Child Table

Discussion in 'Database Discussions' started by Honey_Brinda, Sep 26, 2016.

Tags:
  1. Honey_Brinda

    Honey_Brinda Registered

    Joined:
    May 11, 2016
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    TamilNadu,India
    cPanel Access Level:
    Website Owner
    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.
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     

Share This Page