General discussion

  • Creator
    Topic
  • #2169014

    Refer to the View Field in mysql

    Locked

    by akramsaye ·

    Refer to the View Field in mysql
    Hello!
    I use mysql for my database. I have to refer to a field in my view.
    When I want to insert value to the child table i get the error message (a foreign key constraint fails )
    I know it is before in my sql both the table (child and parent) must not be TEMPORARY tables.
    Any one that has some solution how I can come around this problem.
    I have to have my view but if it is some possibility to copy this view to another table and how I can do it and after it refer to the table which is the copy of my view.

    Thank you for your answer
    Tanha

All Comments

Viewing 0 reply threads