Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

foreign key Not reflected in Child Table

Discussion in 'Database Discussion' 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 Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,809
    Likes Received:
    1,898
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice