How do I customize this query for PhpMyAdmin

ALTER TABLE 'tbl_issue' ADD CONSTRAINT 'FK_issue_project' FOREIGN KEY
('project_id') REFERENCES 'tbl_project' ('id') ON DELETE CASCADE ON
UPDATE RESTRICT;

I am getting an error.
Roslan RamliAdvisorAsked:
Who is Participating?
 
cyberkiwiConnect With a Mentor Commented:
ALTER TABLE tbl_issue ADD CONSTRAINT FK_issue_project FOREIGN KEY
(project_id) REFERENCES tbl_project (id) ON DELETE CASCADE ON
UPDATE RESTRICT;
0
 
mattibuttCommented:
what is the error message you are getting you have  follow the specific version of mysql if its an old version then obviously query wont work
0
 
cyberkiwiCommented:
Or use backquotes ` instead of the single quotes '
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.