This is a test version of Biostars. For the public version, visit https://www.biostars.org.
Problem for adding foreign key

Deal all Can anyone tell me the problem with this command.

mysql> ALTER TABLE Biocyc_2 ADD CONSTRAINT fk_col FOREIGN KEY (User_ids) REFERENCES Unique_reaction (User_ids) on DELETE CASADE ON UPDATE RESTRICT;

It is showing this error. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CASADE ON UPDATE RESTRICT' at line 1 mysql>

mysql
• 808 views • link
written by sharmatina189059 • sharmatina189059

How is this related to bioinformatics?

• 0 views • link
written by Devon Ryan Devon Ryan

Hello sharmatina189059!

We believe that this post does not fit the main topic of this site.

This is not bioinformatics. Please search/ask Stack Overflow.

For this reason we have closed your question. This allows us to keep the site focused on the topics that the community can help with.

If you disagree please tell us why in a reply below, we'll be happy to talk about it.

Cheers!

• 0 views • link
written by Ram Ram

Yes. You are right. I have to ask this question using stack overflow.

• 0 views • link
written by sharmatina189059 • sharmatina189059

0 answers

No answers yet.

Log in to answer this question.

More posts like this