Web Development

General discussion


Refer to the View Field in mysql

By akramsaye ·
Refer to the View Field in mysql
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

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Related Discussions

Related Forums