Solved

How do I customize this query for PhpMyAdmin

Posted on 2010-09-12
3
391 Views
Last Modified: 2012-05-10
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.
0
Comment
Question by:rroslan
  • 2
3 Comments
 
LVL 11

Expert Comment

by:mattibutt
ID: 33656312
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
 
LVL 58

Accepted Solution

by:
cyberkiwi earned 500 total points
ID: 33656323
ALTER TABLE tbl_issue ADD CONSTRAINT FK_issue_project FOREIGN KEY
(project_id) REFERENCES tbl_project (id) ON DELETE CASCADE ON
UPDATE RESTRICT;
0
 
LVL 58

Expert Comment

by:cyberkiwi
ID: 33656328
Or use backquotes ` instead of the single quotes '
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I. Introduction There's an interesting discussion going on now in an Experts Exchange Group — Attachments with no extension (http://www.experts-exchange.com/discussions/210281/Attachments-with-no-extension.html). This reminded me of questions tha…
Join Greg Farro and Ethan Banks from Packet Pushers (http://packetpushers.net/podcast/podcasts/pq-show-93-smart-network-monitoring-paessler-sponsored/) and Greg Ross from Paessler (https://www.paessler.com/prtg) for a discussion about smart network …
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question