Solved

How do I customize this query for PhpMyAdmin

Posted on 2010-09-12
3
365 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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
LDAP find expired users 8 44
Selecting specific rows 3 34
PC upgrade to Linux Mint 7 31
Instering to MySQL table 5 16
Both Easy and Powerful How easy is PHP? http://lmgtfy.com?q=how+easy+is+php (http://lmgtfy.com?q=how+easy+is+php)  Very easy.  It has been described as "a programming language even my grandmother can use." How powerful is PHP?  http://en.wikiped…
Setting up Secure Ubuntu server on VMware 1.      Insert the Ubuntu Server distribution CD or attach the ISO of the CD which is in the “Datastore”. Note that it is important to install the x64 edition on servers, not the X86 editions. 2.      Power on th…
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
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.

708 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now